Sequences not affected by transactions?

by

It would not be a good idea to rollback sequences. Imagine two transactions happening at the same time, each of which uses the sequence for a unique id. If the second transaction commits and the first transaction rolls back, then the second inserted a row with “2” while the first rolls the sequence back to “1”.

If that sequence is then used again, the value of the sequence will become “2” which could lead to a unique constraint problem.

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. How do I do large non-blocking updates in PostgreSQL?
  3. now() default values are all showing same timestamp
  4. Are PostgreSQL functions transactional?
  5. What is PostgreSQL equivalent to autoincrement?
  6. How do I specify a password to ‘psql’ non-interactively?
  7. INSERT with dynamic table name in trigger function
  8. psql: FATAL: Ident authentication failed for user “postgres”
  9. What is the format for the PostgreSQL connection string / URL?
  10. Go and IN clause in Postgres
  11. Where does PostgreSQL store the database?
  12. Is there a way to disable function overloading in Postgres
  13. Grant all on a specific schema in the db to a group role in PostgreSQL
  14. Can I make a plpgsql function return an integer without using a variable?
  15. Migrate database from Postgres to MySQL [closed]
  16. How can I start PostgreSQL on Windows?
  17. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  18. Why can I create a table with PRIMARY KEY on a nullable column?
  19. Oracle SQL Developer and PostgreSQL
  20. Continuing a transaction after primary key violation error
  21. PostgreSQL: Why psql can’t connect to server?
  22. Can I use return value of INSERT…RETURNING in another INSERT?
  23. Changing a postgres containers server port in Docker Compose
  24. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  25. no pg_hba.conf entry for host
  26. PostgreSQL – disabling constraints
  27. PostgreSQL authentication method 10 not supported
  28. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  29. input file appears to be a text format dump. Please use psql
  30. Spring Docker container cannot access Postgres Docker container

Leave a Comment