Fact is, folks are doing it anyway by modifying pg_class. I know one
guy who did it in a transaction so he was the only one to see the
triggers disabled! The PostgreSQL cookbook page has an example too. People are always asking how to do this. Why not just make it setable
only by the super-user.
FYI, TODO has:
* Allow triggers to be disabled [trigger] * With disabled triggers, allow pg_dump to use ALTER TABLE ADD FOREIGN KEY
For practical reasons, I'd prefer the "disable trigger" not to influence fk triggers, or at least to have such a default flavor. When restoring a database, you might consider the data as consistent and complete, so no triggers and ref checks are needed at all. But in the cases of some kind of application data import, you might like the data to have fk ref checked, but don't want to trigger all user triggers.
The implementation of fk checking by triggers should normally be hidden to the user.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
