Alexander Presber <aljoscha@xxxxxxxxxxxx> writes: > Is there a clever, general scheme to "recheck" and enforce foreign > key contraints, after the responsible triggers have been disabled and > reenabled? Drop the constraint (keep your fingers off the trigger, thank you ;-)). Modify the master table. Re-create the constraint before committing. ALTER TABLE ADD FOREIGN KEY does this about as fast as any ad-hoc idea you might come up with. regards, tom lane
