82 error codes for the postgresql platform
Akousa08001The client could not establish a connection to the database server.
08003The specified database connection does not exist or has been closed.
08006An established database connection was unexpectedly lost.
22001A string value is too long for the target column.
22003A numeric value is outside the range of the target column's data type.
22007A date, time, or timestamp value is in an invalid format.
22008A datetime value is outside the valid range for the field.
22012A division by zero was attempted in a SQL expression.
22P02A value could not be converted to the required data type.
23502An INSERT or UPDATE attempted to set a NOT NULL column to NULL.
23503An INSERT or UPDATE violates a foreign key constraint.
23505An INSERT or UPDATE violates a unique constraint or primary key.
23514An INSERT or UPDATE violates a CHECK constraint on the table.
23P01An INSERT or UPDATE violates an exclusion constraint.
25001The command cannot be executed inside an active transaction.
25006An attempt was made to modify data in a read-only transaction.
25P02A command was issued in a transaction that has already failed.
28000The authentication credentials are invalid.
28P01The password provided for authentication is incorrect.
3D000The specified database does not exist.
3F000The specified schema does not exist in the database.
40001The transaction was rolled back due to a serialization conflict.
40P01Two or more transactions are waiting for each other's locks, creating a deadlock.
42000The SQL statement contains a syntax error or violates an access rule.
42501The current user does not have the required privilege.
42601The SQL statement contains a syntax error.
42602An identifier name in the SQL statement is invalid.
42701A column name appears more than once where it must be unique.
42702A column reference is ambiguous because it exists in multiple tables.
42703The specified column does not exist in the table or result set.
42704The specified database object (type, operator, function) does not exist.
42710An object with the specified name already exists.
42712A table alias is used more than once in the same query.
42804The data types in the expression are incompatible.
42830The foreign key definition is invalid due to type mismatch or missing unique constraint.
42883The function with the specified name and argument types does not exist.
42P01The specified table or view does not exist.
42P02A prepared statement parameter is referenced but not defined.
42P03A cursor with the specified name already exists.
42P04A database with the specified name already exists.
42P06A schema with the specified name already exists.
42P07A table with the specified name already exists in the schema.
42P10A column reference in GROUP BY, ORDER BY, or DISTINCT ON is invalid.
42P16The table definition is invalid.
42P18The data type of an expression could not be determined.
53100The database server's disk is full.
53200The database server ran out of memory.
53300The maximum number of database connections has been reached.
54000A database implementation limit was exceeded.
54001The SQL statement is too complex for the database to process.
54011The number of columns exceeds the database limit.
54023Too many arguments were passed to a function.
55000The database object is not in the required state.
55006The database object is currently in use and cannot be modified.
55P03The requested lock could not be acquired without waiting.
57014The query was canceled by the user or a timeout.
57P01The database server is shutting down.
57P02The database server crashed and is restarting.
57P03The database server is not ready to accept connections.
58000An operating system error occurred during a database operation.
58030A disk I/O error occurred during a database operation.
P0001An application-defined exception was raised in PL/pgSQL.
P0002A SELECT INTO in PL/pgSQL returned no rows when exactly one was expected.
P0003A SELECT INTO in PL/pgSQL returned more than one row.
02000The SQL statement completed but returned or affected no rows.
01000A non-critical warning was issued during SQL execution.
0A000The requested SQL feature is not supported by this database.
22004A NULL value was encountered where it is not permitted.
22023A parameter value is invalid for the operation.
22026The string length does not match the expected fixed length.
23001A restrict rule prevented the deletion or update of a referenced row.
24000A cursor operation was attempted in an invalid state.
26000The prepared statement name does not exist.
2B000Privileges cannot be revoked because dependent privileges exist.
2D000A transaction termination command was invalid in the current context.
34000The specified cursor name does not exist or is invalid.
38000An exception occurred in an external function or procedure.
39000An external function was invoked incorrectly.
42809The named object is not the expected type for the operation.
42846The value cannot be automatically converted to the required type.
42P20The window function specification is invalid.
42611A column definition in CREATE TABLE or ALTER TABLE is invalid.