postgres autoincrement not updated on explicit id inserts

by

That’s how it’s supposed to work – next_val('test_id_seq') is only called when the system needs a value for this column and you have not provided one. If you provide value no such call is performed and consequently the sequence is not “updated”.

You could work around this by manually setting the value of the sequence after your last insert with explicitly provided values:

SELECT setval('test_id_seq', (SELECT MAX(id) from "test"));

The name of the sequence is autogenerated and is always tablename_columnname_seq.

More Related Contents:

  1. How to convert primary key from integer to serial?
  2. What’s the PostgreSQL datatype equivalent to MySQL AUTO INCREMENT?
  3. serial in postgres is being increased even though I added on conflict do nothing
  4. How to add an auto-incrementing primary key to an existing table, in PostgreSQL?
  5. Changing primary key int type to serial
  6. What is PostgreSQL equivalent to autoincrement?
  7. How do I specify a password to ‘psql’ non-interactively?
  8. INSERT with dynamic table name in trigger function
  9. psql: FATAL: Ident authentication failed for user “postgres”
  10. What is the format for the PostgreSQL connection string / URL?
  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. PostgreSQL – max number of parameters in “IN” clause?
  18. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  19. Why can I create a table with PRIMARY KEY on a nullable column?
  20. Oracle SQL Developer and PostgreSQL
  21. PostgreSQL array of elements that each are a foreign key
  22. How to reset sequence in postgres and fill id column with new data?
  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. PostgreSQL authentication method 10 not supported
  27. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  28. input file appears to be a text format dump. Please use psql
  29. Hashing a String to a Numeric Value in PostgreSQL
  30. Format specifier for integer variables in format() for EXECUTE?

Leave a Comment