Skip to content

All PostgreSQL errors

Every error in the library, by number and alphabetically. 24 errors so far.

By SQLSTATE

  1. 3D000 database does not exist
  2. 22P02 invalid input syntax for type integer
  3. 25P02 current transaction is aborted, commands ignored until end of transaction block
  4. 28P01 password authentication failed for user
  5. 40P01 deadlock detected
  6. 42P01 relation does not exist
  7. 08001 connection to server failed: Connection refused
  8. 21000 more than one row returned by a subquery used as an expression
  9. 22001 value too long for type character varying
  10. 22003 integer out of range
  11. 23502 null value in column violates not-null constraint
  12. 23503 insert or update on table violates foreign key constraint
  13. 23505 duplicate key value violates unique constraint
  14. 28000 no pg_hba.conf entry for host
  15. 40001 could not serialize access due to concurrent update
  16. 42501 permission denied for table
  17. 42601 syntax error at or near
  18. 42702 column reference is ambiguous
  19. 42703 column does not exist
  20. 42803 column must appear in the GROUP BY clause or be used in an aggregate function
  21. 42804 column is of type integer but expression is of type text
  22. 42883 operator does not exist
  23. 53300 sorry, too many clients already
  24. 57014 canceling statement due to statement timeout

A to Z by message

C

D

I

M

N

O

P

R

S

V