I believe you should be able to use DROP TRIGGER to drop the triggers
once you have their trigger name from pg_trigger.
On Fri, 8 Dec 2000, Bryan (Mailing Lists) wrote:
> I need to remove a FOREIGN KEY constraint; I take it that a foreign key
> constraint is implemented by way of three CONSTRAINT TRIGGERS; however, I
> can find no way to remove or drop a CONSTRAINT TRIGGER. Can someone please
> point me in the right direction?