Postgres - Codigos de Erros

Postgres - Codigos de Erros
 http://pgdocptbr.sourceforge.net/pg80/errcodes-appendix.html

Código de erro	Significado
Class 00	Successful Completion
00000	SUCCESSFUL COMPLETION
Class 01	Warning
01000	WARNING
0100C	DYNAMIC RESULT SETS RETURNED
01008	IMPLICIT ZERO BIT PADDING
01003	NULL VALUE ELIMINATED IN SET FUNCTION
01007	PRIVILEGE NOT GRANTED
01006	PRIVILEGE NOT REVOKED
01004	STRING DATA RIGHT TRUNCATION
01P01	DEPRECATED FEATURE
Class 02	No Data — this is also a warning class per SQL:1999
02000	NO DATA
02001	NO ADDITIONAL DYNAMIC RESULT SETS RETURNED
Class 03	SQL Statement Not Yet Complete
03000	SQL STATEMENT NOT YET COMPLETE
Class 08	Connection Exception
08000	CONNECTION EXCEPTION
08003	CONNECTION DOES NOT EXIST
08006	CONNECTION FAILURE
08001	SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION
08004	SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION
08007	TRANSACTION RESOLUTION UNKNOWN
08P01	PROTOCOL VIOLATION
Class 09	Triggered Action Exception
09000	TRIGGERED ACTION EXCEPTION
Class 0A	Feature Not Supported
0A000	FEATURE NOT SUPPORTED
Class 0B	Invalid Transaction Initiation
0B000	INVALID TRANSACTION INITIATION
Class 0F	Locator Exception
0F000	LOCATOR EXCEPTION
0F001	INVALID LOCATOR SPECIFICATION
Class 0L	Invalid Grantor
0L000	INVALID GRANTOR
0LP01	INVALID GRANT OPERATION
Class 0P	Invalid Role Specification
0P000	INVALID ROLE SPECIFICATION
Class 21	Cardinality Violation
21000	CARDINALITY VIOLATION
Class 22	Data Exception
22000	DATA EXCEPTION
2202E	ARRAY SUBSCRIPT ERROR
22021	CHARACTER NOT IN REPERTOIRE
22008	DATETIME FIELD OVERFLOW
22012	DIVISION BY ZERO
22005	ERROR IN ASSIGNMENT
2200B	ESCAPE CHARACTER CONFLICT
22022	INDICATOR OVERFLOW
22015	INTERVAL FIELD OVERFLOW
2201E	INVALID ARGUMENT FOR LOGARITHM
2201F	INVALID ARGUMENT FOR POWER FUNCTION
2201G	INVALID ARGUMENT FOR WIDTH BUCKET FUNCTION
22018	INVALID CHARACTER VALUE FOR CAST
22007	INVALID DATETIME FORMAT
22019	INVALID ESCAPE CHARACTER
2200D	INVALID ESCAPE OCTET
22025	INVALID ESCAPE SEQUENCE
22010	INVALID INDICATOR PARAMETER VALUE
22020	INVALID LIMIT VALUE
22023	INVALID PARAMETER VALUE
2201B	INVALID REGULAR EXPRESSION
22009	INVALID TIME ZONE DISPLACEMENT VALUE
2200C	INVALID USE OF ESCAPE CHARACTER
2200G	MOST SPECIFIC TYPE MISMATCH
22004	NULL VALUE NOT ALLOWED
22002	NULL VALUE NO INDICATOR PARAMETER
22003	NUMERIC VALUE OUT OF RANGE
22026	STRING DATA LENGTH MISMATCH
22001	STRING DATA RIGHT TRUNCATION
22011	SUBSTRING ERROR
22027	TRIM ERROR
22024	UNTERMINATED C STRING
2200F	ZERO LENGTH CHARACTER STRING
22P01	FLOATING POINT EXCEPTION
22P02	INVALID TEXT REPRESENTATION
22P03	INVALID BINARY REPRESENTATION
22P04	BAD COPY FILE FORMAT
22P05	UNTRANSLATABLE CHARACTER
Class 23	Integrity Constraint Violation
23000	INTEGRITY CONSTRAINT VIOLATION
23001	RESTRICT VIOLATION
23502	NOT NULL VIOLATION
23503	FOREIGN KEY VIOLATION
23505	UNIQUE VIOLATION
23514	CHECK VIOLATION
Class 24	Invalid Cursor State
24000	INVALID CURSOR STATE
Class 25	Invalid Transaction State
25000	INVALID TRANSACTION STATE
25001	ACTIVE SQL TRANSACTION
25002	BRANCH TRANSACTION ALREADY ACTIVE
25008	HELD CURSOR REQUIRES SAME ISOLATION LEVEL
25003	INAPPROPRIATE ACCESS MODE FOR BRANCH TRANSACTION
25004	INAPPROPRIATE ISOLATION LEVEL FOR BRANCH TRANSACTION
25005	NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION
25006	READ ONLY SQL TRANSACTION
25007	SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED
25P01	NO ACTIVE SQL TRANSACTION
25P02	IN FAILED SQL TRANSACTION
Class 26	Invalid SQL Statement Name
26000	INVALID SQL STATEMENT NAME
Class 27	Triggered Data Change Violation
27000	TRIGGERED DATA CHANGE VIOLATION
Class 28	Invalid Authorization Specification
28000	INVALID AUTHORIZATION SPECIFICATION
Class 2B	Dependent Privilege Descriptors Still Exist
2B000	DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST
2BP01	DEPENDENT OBJECTS STILL EXIST
Class 2D	Invalid Transaction Termination
2D000	INVALID TRANSACTION TERMINATION
Class 2F	SQL Routine Exception
2F000	SQL ROUTINE EXCEPTION
2F005	FUNCTION EXECUTED NO RETURN STATEMENT
2F002	MODIFYING SQL DATA NOT PERMITTED
2F003	PROHIBITED SQL STATEMENT ATTEMPTED
2F004	READING SQL DATA NOT PERMITTED
Class 34	Invalid Cursor Name
34000	INVALID CURSOR NAME
Class 38	External Routine Exception
38000	EXTERNAL ROUTINE EXCEPTION
38001	CONTAINING SQL NOT PERMITTED
38002	MODIFYING SQL DATA NOT PERMITTED
38003	PROHIBITED SQL STATEMENT ATTEMPTED
38004	READING SQL DATA NOT PERMITTED
Class 39	External Routine Invocation Exception
39000	EXTERNAL ROUTINE INVOCATION EXCEPTION
39001	INVALID SQLSTATE RETURNED
39004	NULL VALUE NOT ALLOWED
39P01	TRIGGER PROTOCOL VIOLATED
39P02	SRF PROTOCOL VIOLATED
Class 3B	Savepoint Exception
3B000	SAVEPOINT EXCEPTION
3B001	INVALID SAVEPOINT SPECIFICATION
Class 3D	Invalid Catalog Name
3D000	INVALID CATALOG NAME
Class 3F	Invalid Schema Name
3F000	INVALID SCHEMA NAME
Class 40	Transaction Rollback
40000	TRANSACTION ROLLBACK
40002	TRANSACTION INTEGRITY CONSTRAINT VIOLATION
40001	SERIALIZATION FAILURE
40003	STATEMENT COMPLETION UNKNOWN
40P01	DEADLOCK DETECTED
Class 42	Syntax Error or Access Rule Violation
42000	SYNTAX ERROR OR ACCESS RULE VIOLATION
42601	SYNTAX ERROR
42501	INSUFFICIENT PRIVILEGE
42846	CANNOT COERCE
42803	GROUPING ERROR
42830	INVALID FOREIGN KEY
42602	INVALID NAME
42622	NAME TOO LONG
42939	RESERVED NAME
42804	DATATYPE MISMATCH
42P18	INDETERMINATE DATATYPE
42809	WRONG OBJECT TYPE
42703	UNDEFINED COLUMN
42883	UNDEFINED FUNCTION
42P01	UNDEFINED TABLE
42P02	UNDEFINED PARAMETER
42704	UNDEFINED OBJECT
42701	DUPLICATE COLUMN
42P03	DUPLICATE CURSOR
42P04	DUPLICATE DATABASE
42723	DUPLICATE FUNCTION
42P05	DUPLICATE PREPARED STATEMENT
42P06	DUPLICATE SCHEMA
42P07	DUPLICATE TABLE
42712	DUPLICATE ALIAS
42710	DUPLICATE OBJECT
42702	AMBIGUOUS COLUMN
42725	AMBIGUOUS FUNCTION
42P08	AMBIGUOUS PARAMETER
42P09	AMBIGUOUS ALIAS
42P10	INVALID COLUMN REFERENCE
42611	INVALID COLUMN DEFINITION
42P11	INVALID CURSOR DEFINITION
42P12	INVALID DATABASE DEFINITION
42P13	INVALID FUNCTION DEFINITION
42P14	INVALID PREPARED STATEMENT DEFINITION
42P15	INVALID SCHEMA DEFINITION
42P16	INVALID TABLE DEFINITION
42P17	INVALID OBJECT DEFINITION
Class 44	WITH CHECK OPTION Violation
44000	WITH CHECK OPTION VIOLATION
Class 53	Insufficient Resources
53000	INSUFFICIENT RESOURCES
53100	DISK FULL
53200	OUT OF MEMORY
53300	TOO MANY CONNECTIONS
Class 54	Program Limit Exceeded
54000	PROGRAM LIMIT EXCEEDED
54001	STATEMENT TOO COMPLEX
54011	TOO MANY COLUMNS
54023	TOO MANY ARGUMENTS
Class 55	Object Not In Prerequisite State
55000	OBJECT NOT IN PREREQUISITE STATE
55006	OBJECT IN USE
55P02	CANT CHANGE RUNTIME PARAM
55P03	LOCK NOT AVAILABLE
Class 57	Operator Intervention
57000	OPERATOR INTERVENTION
57014	QUERY CANCELED
57P01	ADMIN SHUTDOWN
57P02	CRASH SHUTDOWN
57P03	CANNOT CONNECT NOW
Class 58	System Error (errors external to PostgreSQL itself)
58030	IO ERROR
58P01	UNDEFINED FILE
58P02	DUPLICATE FILE
Class F0	Configuration File Error
F0000	CONFIG FILE ERROR
F0001	LOCK FILE EXISTS
Class P0	PL/pgSQL Error
P0000	PLPGSQL ERROR
P0001	RAISE EXCEPTION
Class XX	Internal Error
XX000	INTERNAL ERROR
XX001	DATA CORRUPTED
XX002	INDEX CORRUPTED