Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> I think it's not a bad idea to suggest that we could have a new command
> ALTER TABLE .. DISABLE CONSTRAINT, which can be run by the table owner
> and paired with a later ALTER TABLE ENABLE CONSTRAINT, which verifies
> the constraint.
The existing, supported way to do this is to drop the foreign key
constraint and then later re-create it.
As noted, if you mess with the triggers directly then any subsequent
breakage is your responsibility.
regards, tom lane