Subject Re: [ib-support] triggers + plan
Author Helen Borrie
At 05:43 PM 09-05-02 +0200, you wrote:
>i´m a new member, and have one question to begin.
>
>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?

I don't know whether a SP would compile containing a plan, but my guess is
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/
_______________________________________________________