- Club d'entraide des développeurs francophones

Code erreur	Signification	Constante
Class 00 -- Successful Completion
`00000`	SUCCESSFUL COMPLETION	successful_completion
Class 01 -- Warning
`01000`	WARNING	warning
`0100C`	DYNAMIC RESULT SETS RETURNED	dynamic_result_sets_returned
`01008`	IMPLICIT ZERO BIT PADDING	implicit_zero_bit_padding
`01003`	NULL VALUE ELIMINATED IN SET FUNCTION	null_value_eliminated_in_set_function
`01007`	PRIVILEGE NOT GRANTED	privilege_not_granted
`01006`	PRIVILEGE NOT REVOKED	privilege_not_revoked
`01004`	STRING DATA RIGHT TRUNCATION	string_data_right_truncation
`01P01`	DEPRECATED FEATURE	deprecated_feature
Class 02 -- No Data (this is also a warning class per the SQL standard)
`02000`	NO DATA	no_data
`02001`	NO ADDITIONAL DYNAMIC RESULT SETS RETURNED	no_additional_dynamic_result_sets_returned
Class 03 -- SQL Statement Not Yet Complete
`03000`	SQL STATEMENT NOT YET COMPLETE	sql_statement_not_yet_complete
Class 08 -- Connection Exception
`08000`	CONNECTION EXCEPTION	connection_exception
`08003`	CONNECTION DOES NOT EXIST	connection_does_not_exist
`08006`	CONNECTION FAILURE	connection_failure
`08001`	SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION	sqlclient_unable_to_establish_sqlconnection
`08004`	SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION	sqlserver_rejected_establishment_of_sqlconnection
`08007`	TRANSACTION RESOLUTION UNKNOWN	transaction_resolution_unknown
`08P01`	PROTOCOL VIOLATION	protocol_violation
Class 09 -- Triggered Action Exception
`09000`	TRIGGERED ACTION EXCEPTION	triggered_action_exception
Class 0A -- Feature Not Supported
`0A000`	FEATURE NOT SUPPORTED	feature_not_supported
Class 0B -- Invalid Transaction Initiation
`0B000`	INVALID TRANSACTION INITIATION	invalid_transaction_initiation
Class 0F -- Locator Exception
`0F000`	LOCATOR EXCEPTION	locator_exception
`0F001`	INVALID LOCATOR SPECIFICATION	invalid_locator_specification
Class 0L -- Invalid Grantor
`0L000`	INVALID GRANTOR	invalid_grantor
`0LP01`	INVALID GRANT OPERATION	invalid_grant_operation
Class 0P -- Invalid Role Specification
`0P000`	INVALID ROLE SPECIFICATION	invalid_role_specification
Class 21 -- Cardinality Violation
`21000`	CARDINALITY VIOLATION	cardinality_violation
Class 22 -- Data Exception
`22000`	DATA EXCEPTION	data_exception
`2202E`	ARRAY SUBSCRIPT ERROR	array_subscript_error
`22021`	CHARACTER NOT IN REPERTOIRE	character_not_in_repertoire
`22008`	DATETIME FIELD OVERFLOW	datetime_field_overflow
`22012`	DIVISION BY ZERO	division_by_zero
`22005`	ERROR IN ASSIGNMENT	error_in_assignment
`2200B`	ESCAPE CHARACTER CONFLICT	escape_character_conflict
`22022`	INDICATOR OVERFLOW	indicator_overflow
`22015`	INTERVAL FIELD OVERFLOW	interval_field_overflow
`2201E`	INVALID ARGUMENT FOR LOGARITHM	invalid_argument_for_logarithm
`2201F`	INVALID ARGUMENT FOR POWER FUNCTION	invalid_argument_for_power_function
`2201G`	INVALID ARGUMENT FOR WIDTH BUCKET FUNCTION	invalid_argument_for_width_bucket_function
`22018`	INVALID CHARACTER VALUE FOR CAST	invalid_character_value_for_cast
`22007`	INVALID DATETIME FORMAT	invalid_datetime_format
`22019`	INVALID ESCAPE CHARACTER	invalid_escape_character
`2200D`	INVALID ESCAPE OCTET	invalid_escape_octet
`22025`	INVALID ESCAPE SEQUENCE	invalid_escape_sequence
`22P06`	NONSTANDARD USE OF ESCAPE CHARACTER	nonstandard_use_of_escape_character
`22010`	INVALID INDICATOR PARAMETER VALUE	invalid_indicator_parameter_value
`22020`	INVALID LIMIT VALUE	invalid_limit_value
`22023`	INVALID PARAMETER VALUE	invalid_parameter_value
`2201B`	INVALID REGULAR EXPRESSION	invalid_regular_expression
`22009`	INVALID TIME ZONE DISPLACEMENT VALUE	invalid_time_zone_displacement_value
`2200C`	INVALID USE OF ESCAPE CHARACTER	invalid_use_of_escape_character
`2200G`	MOST SPECIFIC TYPE MISMATCH	most_specific_type_mismatch
`22004`	NULL VALUE NOT ALLOWED	null_value_not_allowed
`22002`	NULL VALUE NO INDICATOR PARAMETER	null_value_no_indicator_parameter
`22003`	NUMERIC VALUE OUT OF RANGE	numeric_value_out_of_range
`22026`	STRING DATA LENGTH MISMATCH	string_data_length_mismatch
`22001`	STRING DATA RIGHT TRUNCATION	string_data_right_truncation
`22011`	SUBSTRING ERROR	substring_error
`22027`	TRIM ERROR	trim_error
`22024`	UNTERMINATED C STRING	unterminated_c_string
`2200F`	ZERO LENGTH CHARACTER STRING	zero_length_character_string
`22P01`	FLOATING POINT EXCEPTION	floating_point_exception
`22P02`	INVALID TEXT REPRESENTATION	invalid_text_representation
`22P03`	INVALID BINARY REPRESENTATION	invalid_binary_representation
`22P04`	BAD COPY FILE FORMAT	bad_copy_file_format
`22P05`	UNTRANSLATABLE CHARACTER	untranslatable_character
Class 23 -- Integrity Constraint Violation
`23000`	INTEGRITY CONSTRAINT VIOLATION	integrity_constraint_violation
`23001`	RESTRICT VIOLATION	restrict_violation
`23502`	NOT NULL VIOLATION	not_null_violation
`23503`	FOREIGN KEY VIOLATION	foreign_key_violation
`23505`	UNIQUE VIOLATION	unique_violation
`23514`	CHECK VIOLATION	check_violation
Class 24 -- Invalid Cursor State
`24000`	INVALID CURSOR STATE	invalid_cursor_state
Class 25 -- Invalid Transaction State
`25000`	INVALID TRANSACTION STATE	invalid_transaction_state
`25001`	ACTIVE SQL TRANSACTION	active_sql_transaction
`25002`	BRANCH TRANSACTION ALREADY ACTIVE	branch_transaction_already_active
`25008`	HELD CURSOR REQUIRES SAME ISOLATION LEVEL	held_cursor_requires_same_isolation_level
`25003`	INAPPROPRIATE ACCESS MODE FOR BRANCH TRANSACTION	inappropriate_access_mode_for_branch_transaction
`25004`	INAPPROPRIATE ISOLATION LEVEL FOR BRANCH TRANSACTION	inappropriate_isolation_level_for_branch_transaction
`25005`	NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION	no_active_sql_transaction_for_branch_transaction
`25006`	READ ONLY SQL TRANSACTION	read_only_sql_transaction
`25007`	SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED	schema_and_data_statement_mixing_not_supported
`25P01`	NO ACTIVE SQL TRANSACTION	no_active_sql_transaction
`25P02`	IN FAILED SQL TRANSACTION	in_failed_sql_transaction
Class 26 -- Invalid SQL Statement Name
`26000`	INVALID SQL STATEMENT NAME	invalid_sql_statement_name
Class 27 -- Triggered Data Change Violation
`27000`	TRIGGERED DATA CHANGE VIOLATION	triggered_data_change_violation
Class 28 -- Invalid Authorization Specification
`28000`	INVALID AUTHORIZATION SPECIFICATION	invalid_authorization_specification
Class 2B -- Dependent Privilege Descriptors Still Exist
`2B000`	DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST	dependent_privilege_descriptors_still_exist
`2BP01`	DEPENDENT OBJECTS STILL EXIST	dependent_objects_still_exist
Class 2D -- Invalid Transaction Termination
`2D000`	INVALID TRANSACTION TERMINATION	invalid_transaction_termination
Class 2F -- SQL Routine Exception
`2F000`	SQL ROUTINE EXCEPTION	sql_routine_exception
`2F005`	FUNCTION EXECUTED NO RETURN STATEMENT	function_executed_no_return_statement
`2F002`	MODIFYING SQL DATA NOT PERMITTED	modifying_sql_data_not_permitted
`2F003`	PROHIBITED SQL STATEMENT ATTEMPTED	prohibited_sql_statement_attempted
`2F004`	READING SQL DATA NOT PERMITTED	reading_sql_data_not_permitted
Class 34 -- Invalid Cursor Name
`34000`	INVALID CURSOR NAME	invalid_cursor_name
Class 38 -- External Routine Exception
`38000`	EXTERNAL ROUTINE EXCEPTION	external_routine_exception
`38001`	CONTAINING SQL NOT PERMITTED	containing_sql_not_permitted
`38002`	MODIFYING SQL DATA NOT PERMITTED	modifying_sql_data_not_permitted
`38003`	PROHIBITED SQL STATEMENT ATTEMPTED	prohibited_sql_statement_attempted
`38004`	READING SQL DATA NOT PERMITTED	reading_sql_data_not_permitted
Class 39 -- External Routine Invocation Exception
`39000`	EXTERNAL ROUTINE INVOCATION EXCEPTION	external_routine_invocation_exception
`39001`	INVALID SQLSTATE RETURNED	invalid_sqlstate_returned
`39004`	NULL VALUE NOT ALLOWED	null_value_not_allowed
`39P01`	TRIGGER PROTOCOL VIOLATED	trigger_protocol_violated
`39P02`	SRF PROTOCOL VIOLATED	srf_protocol_violated
Class 3B -- Savepoint Exception
`3B000`	SAVEPOINT EXCEPTION	savepoint_exception
`3B001`	INVALID SAVEPOINT SPECIFICATION	invalid_savepoint_specification
Class 3D -- Invalid Catalog Name
`3D000`	INVALID CATALOG NAME	invalid_catalog_name
Class 3F -- Invalid Schema Name
`3F000`	INVALID SCHEMA NAME	invalid_schema_name
Class 40 -- Transaction Rollback
`40000`	TRANSACTION ROLLBACK	transaction_rollback
`40002`	TRANSACTION INTEGRITY CONSTRAINT VIOLATION	transaction_integrity_constraint_violation
`40001`	SERIALIZATION FAILURE	serialization_failure
`40003`	STATEMENT COMPLETION UNKNOWN	statement_completion_unknown
`40P01`	DEADLOCK DETECTED	deadlock_detected
Class 42 -- Syntax Error or Access Rule Violation
`42000`	SYNTAX ERROR OR ACCESS RULE VIOLATION	syntax_error_or_access_rule_violation
`42601`	SYNTAX ERROR	syntax_error
`42501`	INSUFFICIENT PRIVILEGE	insufficient_privilege
`42846`	CANNOT COERCE	cannot_coerce
`42803`	GROUPING ERROR	grouping_error
`42830`	INVALID FOREIGN KEY	invalid_foreign_key
`42602`	INVALID NAME	invalid_name
`42622`	NAME TOO LONG	name_too_long
`42939`	RESERVED NAME	reserved_name
`42804`	DATATYPE MISMATCH	datatype_mismatch
`42P18`	INDETERMINATE DATATYPE	indeterminate_datatype
`42809`	WRONG OBJECT TYPE	wrong_object_type
`42703`	UNDEFINED COLUMN	undefined_column
`42883`	UNDEFINED FUNCTION	undefined_function
`42P01`	UNDEFINED TABLE	undefined_table
`42P02`	UNDEFINED PARAMETER	undefined_parameter
`42704`	UNDEFINED OBJECT	undefined_object
`42701`	DUPLICATE COLUMN	duplicate_column
`42P03`	DUPLICATE CURSOR	duplicate_cursor
`42P04`	DUPLICATE DATABASE	duplicate_database
`42723`	DUPLICATE FUNCTION	duplicate_function
`42P05`	DUPLICATE PREPARED STATEMENT	duplicate_prepared_statement
`42P06`	DUPLICATE SCHEMA	duplicate_schema
`42P07`	DUPLICATE TABLE	duplicate_table
`42712`	DUPLICATE ALIAS	duplicate_alias
`42710`	DUPLICATE OBJECT	duplicate_object
`42702`	AMBIGUOUS COLUMN	ambiguous_column
`42725`	AMBIGUOUS FUNCTION	ambiguous_function
`42P08`	AMBIGUOUS PARAMETER	ambiguous_parameter
`42P09`	AMBIGUOUS ALIAS	ambiguous_alias
`42P10`	INVALID COLUMN REFERENCE	invalid_column_reference
`42611`	INVALID COLUMN DEFINITION	invalid_column_definition
`42P11`	INVALID CURSOR DEFINITION	invalid_cursor_definition
`42P12`	INVALID DATABASE DEFINITION	invalid_database_definition
`42P13`	INVALID FUNCTION DEFINITION	invalid_function_definition
`42P14`	INVALID PREPARED STATEMENT DEFINITION	invalid_prepared_statement_definition
`42P15`	INVALID SCHEMA DEFINITION	invalid_schema_definition
`42P16`	INVALID TABLE DEFINITION	invalid_table_definition
`42P17`	INVALID OBJECT DEFINITION	invalid_object_definition
Class 44 -- WITH CHECK OPTION Violation
`44000`	WITH CHECK OPTION VIOLATION	with_check_option_violation
Class 53 -- Insufficient Resources
`53000`	INSUFFICIENT RESOURCES	insufficient_resources
`53100`	DISK FULL	disk_full
`53200`	OUT OF MEMORY	out_of_memory
`53300`	TOO MANY CONNECTIONS	too_many_connections
Class 54 -- Program Limit Exceeded
`54000`	PROGRAM LIMIT EXCEEDED	program_limit_exceeded
`54001`	STATEMENT TOO COMPLEX	statement_too_complex
`54011`	TOO MANY COLUMNS	too_many_columns
`54023`	TOO MANY ARGUMENTS	too_many_arguments
Class 55 -- Object Not In Prerequisite State
`55000`	OBJECT NOT IN PREREQUISITE STATE	object_not_in_prerequisite_state
`55006`	OBJECT IN USE	object_in_use
`55P02`	CANT CHANGE RUNTIME PARAM	cant_change_runtime_param
`55P03`	LOCK NOT AVAILABLE	lock_not_available
Class 57 -- Operator Intervention
`57000`	OPERATOR INTERVENTION	operator_intervention
`57014`	QUERY CANCELED	query_canceled
`57P01`	ADMIN SHUTDOWN	admin_shutdown
`57P02`	CRASH SHUTDOWN	crash_shutdown
`57P03`	CANNOT CONNECT NOW	cannot_connect_now
Class 58 -- System Error (errors external to PostgreSQL™ itself)
`58030`	IO ERROR	io_error
`58P01`	UNDEFINED FILE	undefined_file
`58P02`	DUPLICATE FILE	duplicate_file
Class F0 -- Configuration File Error
`F0000`	CONFIG FILE ERROR	config_file_error
`F0001`	LOCK FILE EXISTS	lock_file_exists
Class P0 -- PL/pgSQL Error
`P0000`	PLPGSQL ERROR	plpgsql_error
`P0001`	RAISE EXCEPTION	raise_exception
`P0002`	NO DATA FOUND	no_data_found
`P0003`	TOO MANY ROWS	too_many_rows
Class XX -- Internal Error
`XX000`	INTERNAL ERROR	internal_error
`XX001`	DATA CORRUPTED	data_corrupted
`XX002`	INDEX CORRUPTED	index_corrupted

Documentation PostgreSQL 8.2.5 -

Partie VIII. Annexes

A. Codes d'erreurs de PostgreSQL