DB
Pro
Product
Pricing
Download
About
Blog
Help
DB Pro Cloud
Learn
/
PostgreSQL
/
Errors
PostgreSQL Errors
Common errors with causes, solutions, and examples.
Authentication
password authentication failed
no pg_hba.conf entry for host
Connection
database does not exist
could not connect to server
connection refused
Constraint
duplicate key value violates unique constraint
violates foreign key constraint
null value in column violates not-null constraint
new row violates check constraint
conflicting key value violates exclusion constraint
Data
value too long for type character varying
invalid input syntax for type
numeric value out of range
column cannot be cast to type
Lock
could not obtain lock
Object
relation does not exist
column does not exist
database already exists
relation already exists
duplicate key value violates unique constraint on type/function
function does not exist
Permission
permission denied for table
Resource
could not extend file: No space left on device
out of memory
Syntax
syntax error at or near
LIMIT must not be negative
Timeout
canceling statement due to user request
Transaction
could not serialize access
deadlock detected
cannot execute in a read-only transaction
