> >Yes, a combination of the two would probably be better. You would need
> >to be careful about function call names for FKeys, there are a fair
> >number of them. Checking for 3 triggers with the function name starting
> >with RI_FKey* would probably be better.
>
> Will the tgisconstraint flag always be set for these triggers? Will
> the function names still be RI_FKey* once these databases are migrated
> to postgres 7.4 or later?
Until someone has a good reason to change things, they'll probably stay
the same, so you will probably get a release or two out of it.
But it is much easier to change the internal structures now, as
PostgreSQL doesn't have nearly as much of a backward compatibility issue
anymore.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
