On May 29, 2007, at 12:41 , Jeff Davis wrote:
"CREATE CONSTRAINT TRIGGER is used within CREATE TABLE/ALTER TABLE and
by pg_dump to create the special triggers for referential
integrity. It
is not intended for general use."
Is there harm in using constraint triggers outside of pg_dump? It
seems
like deferrable constraints would be useful for many applications, but
the docs imply that it's a bad idea.
It's a PostgreSQL extension, so it's nonstandard, but my
understanding is that it's safe to use and there are no current plans
to make it go away. As long as you understand what you're doing, I
don't know of any problems with using CREATE CONSTRAINT TRIGGER. I've
asked similar questions in the past, so you might want to check the
archives.
Michael Glaesemann
grzm seespotcode net
PS: Nice to meet you at PGCon. Hope you enjoyed it as much as I did!
It was good to meet you too, Jeff! Hope to see you at the next
gathering :)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
