postgresql duplicate key violates unique constraint

Hi i have a question i know this was posted many times but i didn’t find an answer to my problem. The problem is that i have a table and a column “id” i want it to be unique number just as normal. This type of column is serial and the next value after each insert is comming from a sequence so everything seems to be all right but it still sometimes showing this error. I dont know why ? In the documentation it is writtne the sequence is fool prof and always works. If I add a UNIQUE constraint to that column will it thelp ? I worked before many times on Postres but this error is showing for me for the first time. I did everything as normal and i never had this problem before. Can you help me to find the answer that can be used in the future for all tables that will be created ? Lets say we have something easy like this:

CREATE TABLE comments
(
  id serial NOT NULL,
  some_column text NOT NULL,
  CONSTRAINT id_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE interesting.comments OWNER TO postgres;

If i add:

ALTER TABLE comments ADD CONSTRAINT id_id_key UNIQUE(id)

Will if be enought or is there some other thing that should be done ?

Related Posts:

  1. PostgreSQL: Show tables in PostgreSQL
  2. Psql could not connect to server: No such file or directory, 5432 error?
  3. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  4. What is the format for the PostgreSQL connection string / URL?
  5. “use database_name” command in PostgreSQL
  6. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  7. psql: FATAL: Ident authentication failed for user “postgres”
  8. fe_sendauth: no password supplied
  9. How can I drop all the tables in a PostgreSQL database?
  10. How to restart PostgreSQL in Ubuntu 18.04
  11. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  12. Postgresql: Scripting psql execution with password
  13. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  14. How to change PostgreSQL user password?
  15. No function matches the given name and argument types
  16. PostgreSQL error: Fatal: role “username” does not exist
  17. How to change PostgreSQL user password?
  18. How to exit from PostgreSQL command line utility: psql
  19. psql: FATAL: database “” does not exist
  20. eroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  21. Permission denied for relation
  22. postgres does not know where to find server configuration
  23. input file appears to be a text format dump. Please use psql
  24. PG COPY error: invalid input syntax for integer
  25. Postgres: INSERT if does not exist already
  26. What’s the default superuser username/password for postgres after a new install?
  27. How to see active connections and “current activity” in PostgreSQL 8.4
  28. pg_dump and pg_restore: input file does not appear to be a valid archive
  29. What is this JavaScript “require”?
  30. What is this JavaScript “require”?
  31. PostgreSQL “DESCRIBE TABLE”
  32. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  33. How to restart Postgresql
  34. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  35. What is the default password for Postgres
  36. Postgresql 9.2 pg_dump version mismatch
  37. missing FROM-clause entry for table
  38. PostgreSQL: Remotely connecting to Postgres instance using psql command
  39. Simple Random Samples from a Sql database
  40. Insert text with single quotes in PostgreSQL
  41. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  42. Cannot simply use PostgreSQL table name (“relation does not exist”)
  43. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  44. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  45. could not connect to server: No such file or directory (PG::ConnectionBad)
  46. Postgresql tables exists, but getting “relation does not exist” when querying
  47. PG::ConnectionBad: fe_sendauth: no password supplied
  48. “extra data after last expected column” while trying to import a csv file into postgresql
  49. postgresql: error duplicate key value violates unique constraint
  50. psql: command not found Mac
  51. pg_ctl: no database directory specified and environment variable PGDATA unset
  52. psql: FATAL: role “postgres” does not exist
  53. Postgres Error: More than one row returned by a subquery used as an expression
  54. PostgreSQL: Query has no destination for result data
  55. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  56. PostgreSQL create table if not exists
  57. updating table rows in postgres using subquery
  58. PostgreSQL visual interface similar to phpMyAdmin?
  59. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  60. GROUP BY and COUNT using ActiveRecord
  61. Postgresql column reference “id” is ambiguous
  62. What is a postgres superuser
  63. GRANT SELECT to all tables in postgresql
  64. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  65. Postgres equivalent to MySQL’s \G?
  66. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  67. Postgres equivalent to MySQL’s \G?
  68. Postgres equivalent to MySQL’s \G?

Leave a Comment