How do I temporarily disable triggers in PostgreSQL?

by

Alternatively, if you are wanting to disable all triggers, not just those on the USER table, you can use: 

SET session_replication_role = replica;

This disables triggers for the current session.

To re-enable for the same session:

SET session_replication_role = DEFAULT;

Source: http://koo.fi/blog/2013/01/08/disable-postgresql-triggers-temporarily/

More Related Contents:

  1. INSERT with dynamic table name in trigger function
  2. What’s the fastest way to do a bulk insert into Postgres?
  3. Passing user id to PostgreSQL triggers
  4. How do I get a column with consecutive, increasing numbers, without having any numbers missing?
  5. Refresh a materialized view automatically using a rule or notify
  6. Postgresql insert trigger to set value
  7. ERROR: unterminated quoted string at or near
  8. Is there a way to disable updates/deletes but still allow triggers to perform them?
  9. PostgreSQL – set a default cell value according to another cell value
  10. Why the “Group BY” by month didn’t work? [closed]
  11. What to do with null values when modeling and normalizing?
  12. Postgres: INSERT if does not exist already
  13. Truncating all tables in a Postgres database
  14. How can I drop all the tables in a PostgreSQL database?
  15. postgres default timezone
  16. quick random row selection in Postgres
  17. Running PostgreSQL in memory only
  18. How do I login and authenticate to Postgresql after a fresh install?
  19. pgadmin4 : postgresql application server could not be contacted.
  20. PostgreSQL error ‘Could not connect to server: No such file or directory’
  21. eliminate duplicate array values in postgres
  22. Find Parent Recursively using Query
  23. How to see the CREATE VIEW code for a view in PostgreSQL?
  24. How can I ensure that a materialized view is always up to date?
  25. PostgreSQL: Query has no destination for result data
  26. Postgres trigger after insert accessing NEW
  27. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  28. postgresql error PANIC: could not locate a valid checkpoint record
  29. Syntax error at end of input in PostgreSQL
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment