Re: Removing Referential Integrity

On Sat, 25 May 2002, Doug Fields wrote:

> Hi all,
>
> In 7.2.1...
>
> I have a few tables built with REFERENCES for which I would like to
> permanently remove these constraints in the search of higher performance
> INSERTs.
>
> From pg_dump, I see these commands:
>
> -- Disable triggers
> UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'accounts';
> -- Enable triggers
> UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where
> pg_class.oid = tgrelid) WHERE relname = 'accounts';
>
> I'm not sure, however, if that actually permanently removes the CONSTRAINT
> TRIGGER. There does not seem to be an equivalent REMOVE CONSTRAINT TRIGGER,
> and DROP TRIGGER won't work on the trigger reported by psql's \d command.
>
> Any thoughts?

Drop trigger should work fine as long as you double quote the names
because they're mixed case.