PostgreSQL 8.1 文档 · 附录 A. PostgreSQL错误代码

文档 → PostgreSQL 8.1

受支持版本：当前版本 (18) / 17 / 16 / 15 / 14

测试与开发版本： 19 / devel

不受支持的版本： 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4

历史版本PostgreSQL 8.1 已于 2010 年 11 月结束社区维护，本页译文保留供仍在使用旧版本的读者参考。新系统请看当前版本。

附录 A. PostgreSQL错误代码
上一页	上一级	部分 VIII. 附录	起始页	下一页

附录 A. PostgreSQL错误代码

PostgreSQL 服务器发出的所有消息都被分配了五字符错误代码，遵循 SQL 标准对 “SQLSTATE” 代码的约定。需要知道发生了哪一种错误条件的应用，通常应测试错误代码，而不是查看错误消息的文本内容。这些错误代码在不同 PostgreSQL 版本之间更不容易发生变化，也不会因错误消息的本地化而改变。请注意，PostgreSQL 产生的错误代码中，只有一部分由 SQL 标准定义；还有一些用于标准未定义情况的附加错误代码，是新设的或从其他数据库借用而来的。

根据标准，错误代码的前两个字符表示错误类别，后三个字符表示该类别中的特定条件。因此，即使应用无法识别某个具体错误代码，仍可能从错误类别推断出应采取的操作。

表 A.1列出了 PostgreSQL 8.1.23 中定义的所有错误代码。（其中有些当前实际上并未使用，不过它们由 SQL 标准定义。）其中也显示了错误类别。对于每个错误类别，都有一个后三个字符为 000 的“标准”错误代码。该代码只用于那些属于该类别但没有分配更具体代码的错误情况。

每个错误代码的 PL/pgSQL 条件名与表中所示的短语相同，只是把空格替换成下划线。例如，代码 22012（DIVISION BY ZERO）的条件名是 DIVISION_BY_ZERO。条件名可以大写或小写。（注意， PL/pgSQL 不识别警告（而非错误）的条件名；它们是类别 00、01 和 02。）

表 A.1. PostgreSQL错误代码

Error Code	Meaning	Constant
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
Class XX — Internal Error
`XX000`	INTERNAL ERROR	internal_error
`XX001`	DATA CORRUPTED	data_corrupted
`XX002`	INDEX CORRUPTED	index_corrupted

上一页	上一级	下一页
部分 VIII. 附录	起始页	附录 B. 日期/时间支持

提交更正

译文有误、术语不当或页面显示问题，请到译文仓库 pgsty/pgdoc 报告译文问题。英文原文本身的问题，请在当前版本的对应页面向上游反馈；上游不再修订已结束维护的版本。