Subject | Re: [ib-support] triggers + plan |
---|---|
Author | Helen Borrie |
Post date | 2002-05-10T13:34:50Z |
At 05:43 PM 09-05-02 +0200, you wrote:
no. Even if it would, it might not be such a good idea, since the names of
system-generated indexes change when the database is backed up and restored
and would thus corrupt a compiled procedure that referred to these indexes
by way of a plan.
Helen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________
>i´m a new member, and have one question to begin.I don't know whether a SP would compile containing a plan, but my guess is
>
>i have a linux redhat 6.2 with interbase 5.6 server, and the question is
>very simple, can i use a plan expression inside table's triggers?
no. Even if it would, it might not be such a good idea, since the names of
system-generated indexes change when the database is backed up and restored
and would thus corrupt a compiled procedure that referred to these indexes
by way of a plan.
Helen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________