Mikko Kortelainen

Temporarily Disable PostgreSQL Triggers

To temporarily disable all triggers in a PostgreSQL session, use this:

SET session_replication_role = replica;

That disables all triggers for the current database session only. Useful for bulk operations, but remember to be careful to keep your database consistent.

To re-enable:

SET session_replication_role = DEFAULT;

Disable a Single Trigger

To disable just …

read more
<< Page 8 of 15 >>