PostgreSQL tutorial. Error messages help: cause and solution.
- Column must appear in the GROUP BY clause
- Column specified more than once
- Constraint for relation already exists
- Constraint of relation does not exist
- Control reaches end of function without return
- ERROR: cannot begin/end transactions in PL/pgSQL
- Duplicate key value violates unique constraint
- Duplicate key value violates NOT NULL unique constraint
- INSERT has more target columns than expressions
- Invalid input syntax for type boolean
- Multiple primary keys for table are not allowed
- Negative substring length not allowed
- Null value in column violates not-null constraint
- PostgreSQL Numeric field overflow
- Relation does not exist
- Value too long for type character varying or type numeric