Prevent recursive trigger in PostgreSQL

by

This is what I do in PostgreSQL 9.2, although I must admit I did not find this approach documented. There is a function pg_trigger_depth() documented here, which I use to differentiate between original and nested calls in the trigger.

CREATE TRIGGER trg_taxonomic_positions
AFTER INSERT OR UPDATE OF taxonomic_position
ON taxon_concepts
FOR EACH ROW
WHEN (pg_trigger_depth() = 0)
EXECUTE PROCEDURE trg_taxonomic_positions()

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. INSERT with dynamic table name in trigger function
  4. Use multiple conflict_target in ON CONFLICT clause
  5. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  6. How to find table creation time?
  7. What is the format for the PostgreSQL connection string / URL?
  8. Go and IN clause in Postgres
  9. Where does PostgreSQL store the database?
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. Grant all on a specific schema in the db to a group role in PostgreSQL
  13. Can I make a plpgsql function return an integer without using a variable?
  14. Migrate database from Postgres to MySQL [closed]
  15. How can I start PostgreSQL on Windows?
  16. PostgreSQL – max number of parameters in “IN” clause?
  17. Can’t connect the postgreSQL with psycopg2
  18. How do you change the character encoding of a postgres database?
  19. Difference between GiST and GIN index
  20. Test for null in function with varying parameters
  21. PostgreSQL: Why psql can’t connect to server?
  22. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  23. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  24. no pg_hba.conf entry for host
  25. PostgreSQL – disabling constraints
  26. How to delete an enum type value in postgres?
  27. Why unsigned integer is not available in PostgreSQL?
  28. now() default values are all showing same timestamp
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment