CODEWITHSUNDEEP
postgresqldatabase-triggercascade
Andy
Andy

Reputation: 8662

Postgres: DISABLE TRIGGER ALL and ON UPDATE CASCADE

It seems like when I 

ALTER TABLE foo DISABLE TRIGGER ALL;
DELETE FROM foo;

The deletions don't get cascaded to other tables with

FOREIGN KEY ("fooId") REFERENCES "foo"("id") ON DELETE CASCADE

constraints, but I can't find anything in the documentation about this. I also don't see any triggers I didn't create in

SELECT * FROM information_schema.triggers;

I'm guessing ON UPDATE/ON DELETE are implemented internally as triggers (which aren't visible in pgAdmin)? Does anyone know where this is documented?

Upvotes: 0

Views: 3858

Answers (1)

Renato
Renato

Reputation: 2157

Try here:

DISABLE/ENABLE [ REPLICA | ALWAYS ] TRIGGER
These forms configure the firing of trigger(s) belonging to the table. A disabled trigger is still known to the system, but is not executed when its triggering event occurs. For a deferred trigger, the enable status is checked when the event occurs, not when the trigger function is actually executed. One can disable or enable a single trigger specified by name, or all triggers on the table, or only user triggers (this option excludes internally generated constraint triggers such as those that are used to implement foreign key constraints or deferrable uniqueness and exclusion constraints). Disabling or enabling internally generated constraint triggers requires superuser privileges; it should be done with caution since of course the integrity of the constraint cannot be guaranteed if the triggers are not executed.

Upvotes: 3

Related Questions