Brian McCane <bmccane@mccons.net> writes:
> Thanks Tom and Arguile that definitely helps. Now for my more
> pressing, but forgotten question. Shouldn't PostgreSQL have automatically
> dropped that trigger when I dropped the table?
It should, and it does.
IIRC, there's a bug in some versions of pg_dump that loses the
connection between a foreign-key trigger and the referenced table
(ie, the tgconstrrelid link) when you dump and reload. If you can
exhibit an instance of misbehavior otherwise, I'd like to see it.
regards, tom lane