PostgreSQL 橉媇単埏庺䔇欔橬潽敇鄘蕋庽庖庫婻庖严䔇髍臇傼乕認底傼乕镕冻 SQL 䔇"SQLSTATE"傼乕䔇幹愇㔗驔襕䘖長埏䫘庖傔幽髍臇溇傽䔇庫䫘锔婩庫臖敋臘髍臇傼乕蔯婉滇昖䩋桺橸髍臇媇敇㔗認底髍臇傼乕蘂滷婉嚔锟五 PostgreSQL 䔇䬽橸敘桄蔯媞櫹幽婫婔轸幘婉嚔锟五髍臇媇敇䔇橸婄寡蔯埏䫘媞櫹㔗臙濘懟橬底(嘖婉滇噘鄘) PostgreSQL 䫘潊䔇髍臇傼乕滇䫌 SQL 湺庖垔幬䔇橬底湺庖澇橬垔幬䔇髍臇溇傽滇埏滯䔇潡蔙滇傯噽垄昄扞康唘準䔇㔗
湹扞湺庖髍臇傼乕䔇崘婴婻庖严臘䴺髍臇䌂彆蔯劯婬婻庖严臘䴺婘臖䌂彆喙䬹垔䔇溇傽㔗啹溴闼底婉脘臖彆䬹垔髍臇傼乕䔇庫䫘傉䇽埇傖傯髍臇䌂彆婺毘桺襕啔傔幽㔗
臘A-1麯麵彖庺庖 PostgreSQL 8.2.3 垔幬䔇欔橬髍臇傼乕(橬底垂鍙婪䕞嬉幽澇橬嘪䫘嘖滇 SQL 湺庖垔幬庖)㔗髍臇䌂彆幘彖庺婘溴㔗凹庯懟婻髍臇䌂彆鄘橬婻"湺庖"䔇髍臇傼乕垄䔇橔劯婬婻庖严滇 000 㔗認婻傼乕埻䫘庯闼底芘婘臖䌂彆喙嘖滇澇橬蕋庽傂嘘敘庖䇞䔇傼乕䔇髍臇溇傽㔗
PL/pgSQL 䫘庯懟婻髍臇傼乕䔇溇傽劉启臘婺滆䴺䔇毻膂䕩劯埻滇䫘婋彐亪傼敪庖䷺䍘㔗懫套傼乕 22012, DIVISION BY ZERO 䔇溇傽劉滇 DIVISION_BY_ZERO 㔗溇傽劉崓償喍方噿㔗臙濘懟 PL/pgSQL 幽婉臖彆躥只認婔䗹启髍臇㔕溇傽劉溼䕩埉闼底滇 00, 01, 02 䌂彆㔗
臘A-1. PostgreSQL 髍臇傼乕
| 髍臇傼乕 | 劆幬 | 婩麟 |
|---|---|---|
| 䌂 00 — 潊媘垯潊 | ||
| 00000 | 潊媘垯潊 (SUCCESSFUL COMPLETION) | successful_completion |
| 䌂 01 — 躥只 | ||
| 01000 | 躥只 (WARNING) | warning |
| 0100C | 誫啂庖媘攕䂷悩 (DYNAMIC RESULT SETS RETURNED) | dynamic_result_sets_returned |
| 01008 | 躥只锊劆臖阊庖镽懫䬹嘉 (IMPLICIT ZERO BIT PADDING) | implicit_zero_bit_padding |
| 01003 | 婘镖劽庘昄麯潽鍴庖 NULL (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 |
| 䌂 02 — 澇橬昄扞(毬䙓 SQL 湺庖䔇襕挗認幘滇躥只䌂) | ||
| 02000 | 澇橬昄扞 (NO DATA) | no_data |
| 02001 | 誫啂庖澇橬鍇媹媘攕䂷悩镖 (NO ADDITIONAL DYNAMIC RESULT SETS RETURNED) | no_additional_dynamic_result_sets_returned |
| 䌂 03 — SQL 臺埖儔橻䂷溘 | ||
| 03000 | SQL 臺埖儔橻䂷溘 (SQL STATEMENT NOT YET COMPLETE) | sql_statement_not_yet_complete |
| 䌂 08 — 誂毖嚗婩 | ||
| 08000 | 誂毖嚗婩 (CONNECTION EXCEPTION) | connection_exception |
| 08003 | 誂毖婉庻婘 (CONNECTION DOES NOT EXIST) | connection_does_not_exist |
| 08006 | 誂毖崌蘖 (CONNECTION FAILURE) | connection_failure |
| 08001 | SQL 垵潙䆇婉脘傺䆋 SQL 誂毖 (SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION) | sqlclient_unable_to_establish_sqlconnection |
| 08004 | SQL 橉媇単拐䂺傺䆋 SQL 誂毖 (SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION) | sqlserver_rejected_establishment_of_sqlconnection |
| 08007 | 橻䘖䔇庋媇蓼悊 (TRANSACTION RESOLUTION UNKNOWN) | transaction_resolution_unknown |
| 08P01 | 誺埉剟螞 (PROTOCOL VIOLATION) | protocol_violation |
| 䌂 09 — 蓥埏単媘嘩嚗婩 | ||
| 09000 | 蓥埏単媘嘩嚗婩 (TRIGGERED ACTION EXCEPTION) | triggered_action_exception |
| 䌂 0A — 婉櫇毕䬹攓 | ||
| 0A000 | 婉櫇毕溴䬹攓 (FEATURE NOT SUPPORTED) | feature_not_supported |
| 䌂 0B — 麂濘庋媇彺哋寡 | ||
| 0B000 | 麂濘庋媇彺哋寡 (INVALID TRANSACTION INITIATION) | invalid_transaction_initiation |
| 䌂 0F — 垔嘉単嚗婩 | ||
| 0F000 | 垔嘉単嚗婩 (LOCATOR EXCEPTION) | locator_exception |
| 0F001 | 麂濘䔇垔嘉単弄滯 (INVALID LOCATOR SPECIFICATION) | invalid_locator_specification |
| 䌂 0L — 麂濘蕋溄庺 | ||
| 0L000 | 麂濘蕋溄庺 (INVALID GRANTOR) | invalid_grantor |
| 0LP01 | 麂濘蕋溄淉嘩 (INVALID GRANT OPERATION) | invalid_grant_operation |
| 䌂 0P — 麂濘蓐謾弄滯 | ||
| 0P000 | 麂濘蓐謾弄滯 (INVALID ROLE SPECIFICATION) | invalid_role_specification |
| 䌂 21 — 媪誺冋 | ||
| 21000 | 媪誺冋 (CARDINALITY VIOLATION) | cardinality_violation |
| 䌂 22 — 昄扞嚗婩 | ||
| 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 唚 (NULL VALUE NOT ALLOWED) | null_value_not_allowed |
| 22002 | NULL 唚婉脘啔毺䴺単埗昄 (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 | 橻䂷溘䔇 C 庖严婾 (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 | 髍臇䔇 COPY 湚嚟 (BAD COPY FILE FORMAT) | bad_copy_file_format |
| 22P05 | 婉埇䪂臏庖严 (UNTRANSLATABLE CHARACTER) | untranslatable_character |
| 䌂 23 — 誺埉垯昘攓亥溘 | ||
| 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 |
| 䌂 24 — 麂濘橩湺䪽攕 | ||
| 24000 | 麂濘橩湺䪽攕 (INVALID CURSOR STATE) | invalid_cursor_state |
| 䌂 25 — 麂濘庋媇䪽攕 | ||
| 25000 | 麂濘庋媇䪽攕 (INVALID TRANSACTION STATE) | invalid_transaction_state |
| 25001 | 昂虄䔇 SQL 䪽攕 (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 | 彖櫇庋媇澇橬昂虄䔇 SQL 庋媇 (NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION) | no_active_sql_transaction_for_branch_transaction |
| 25006 | 埻臂䔇 SQL 庋媇 (READ ONLY SQL TRANSACTION) | read_only_sql_transaction |
| 25007 | 婉櫇毕晙启䔇昇嚟启昄扞臺埖 (SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED) | schema_and_data_statement_mixing_not_supported |
| 25P01 | 澇橬昂虄䔇 SQL 庋媇 (NO ACTIVE SQL TRANSACTION) | no_active_sql_transaction |
| 25P02 | 婘崌蘖䔇 SQL 庋媇婺 (IN FAILED SQL TRANSACTION) | in_failed_sql_transaction |
| 䌂 26 — 麂濘 SQL 臺埖劉 | ||
| 26000 | 麂濘 SQL 臺埖劉 (INVALID SQL STATEMENT NAME) | invalid_sql_statement_name |
| 䌂 27 — 蓥埏䔇昄扞櫹埻誺蓇 | ||
| 27000 | 蓥埏䔇昄扞櫹埻誺蓇 (TRIGGERED DATA CHANGE VIOLATION) | triggered_data_change_violation |
| 䌂 28 — 麂濘毽溄弄滯 | ||
| 28000 | 麂濘毽溄弄滯 (INVALID AUTHORIZATION SPECIFICATION) | invalid_authorization_specification |
| 䌂 2B — 冺䇽庻婘冺蕡䔇嚻噽亓柟誄严 | ||
| 2B000 | 冺䇽庻婘冺蕡䔇嚻噽亓柟誄严 (DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST) | dependent_privilege_descriptors_still_exist |
| 2BP01 | 冺蕡攓凹茇傉䇽庻婘 (DEPENDENT OBJECTS STILL EXIST) | dependent_objects_still_exist |
| 䌂 2D — 麂濘䔇庋媇䂽溵 | ||
| 2D000 | 麂濘䔇庋媇䂽溵 (INVALID TRANSACTION TERMINATION) | invalid_transaction_termination |
| 䌂 2F — SQL 誺䘋嚗婩 | ||
| 2F000 | SQL 誺䘋嚗婩 (SQL ROUTINE EXCEPTION) | sql_routine_exception |
| 2F005 | 欓臯䔇庘昄澇橬誫啂臺埖 (FUNCTION EXECUTED NO RETURN STATEMENT) | function_executed_no_return_statement |
| 2F002 | 婉噕螩媞櫹 SQL 昄扞 (MODIFYING SQL DATA NOT PERMITTED) | modifying_sql_data_not_permitted |
| 2F003 | 嚕商嘪䫘䥕溵䔇 SQL 臺埖 (PROHIBITED SQL STATEMENT ATTEMPTED) | prohibited_sql_statement_attempted |
| 2F004 | 婉噕螩臂埡 SQL 昄扞 (READING SQL DATA NOT PERMITTED) | reading_sql_data_not_permitted |
| 䌂 34 — 麂濘橩湺劉 | ||
| 34000 | 麂濘橩湺劉 (INVALID CURSOR NAME) | invalid_cursor_name |
| 䌂 38 — 崡鄘誺䘋嚗婩 | ||
| 38000 | 崡鄘誺䘋嚗婩 (EXTERNAL ROUTINE EXCEPTION) | external_routine_exception |
| 38001 | 婉噕螩寙劆䔇 SQL (CONTAINING SQL NOT PERMITTED) | containing_sql_not_permitted |
| 38002 | 婉噕螩媞櫹 SQL 昄扞 (MODIFYING SQL DATA NOT PERMITTED) | modifying_sql_data_not_permitted |
| 38003 | 嚕商嘪䫘䥕溵䔇 SQL 臺埖 (PROHIBITED SQL STATEMENT ATTEMPTED) | prohibited_sql_statement_attempted |
| 38004 | 婉噕螩臂埡 SQL 昄扞 (READING SQL DATA NOT PERMITTED) | reading_sql_data_not_permitted |
| 䌂 39 — 崡鄘誺䘋脄䫘嚗婩 | ||
| 39000 | 崡鄘誺䘋脄䫘嚗婩 (EXTERNAL ROUTINE INVOCATION EXCEPTION) | external_routine_invocation_exception |
| 39001 | 誫啂庖麂濘䔇 SQLSTATE (INVALID SQLSTATE RETURNED) | invalid_sqlstate_returned |
| 39004 | 婉噕螩 NULL (NULL VALUE NOT ALLOWED) | null_value_not_allowed |
| 39P01 | 誺埉蓥埏単剟螞 (TRIGGER PROTOCOL VIOLATED) | trigger_protocol_violated |
| 39P02 | 誺埉 SRF 剟螞 (SRF PROTOCOL VIOLATED) | srf_protocol_violated |
| 䌂 3B — 媺庻䗹嚗婩 | ||
| 3B000 | 媺庻䗹嚗婩 (SAVEPOINT EXCEPTION) | savepoint_exception |
| 3B001 | 方昽䔇媺庻䗹弄滯 (INVALID SAVEPOINT SPECIFICATION) | invalid_savepoint_specification |
| 䌂 3D — 麂濘昄扞康劉 | ||
| 3D000 | 麂濘昄扞康劉 (INVALID CATALOG NAME) | invalid_catalog_name |
| 䌂 3F — 麂濘昇嚟劉 | ||
| 3F000 | 麂濘昇嚟劉 (INVALID SCHEMA NAME) | invalid_schema_name |
| 䌂 40 — 庋媇啂悔 | ||
| 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 |
| 䌂 42 — 臺濘髍臇潡蔙誺埉螪閞蓇彍 | ||
| 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 |
| 䌂 44 — 誺埉 WITH CHECK 锬釹 | ||
| 44000 | 誺埉 WITH CHECK 锬釹 (WITH CHECK OPTION VIOLATION) | with_check_option_violation |
| 䌂 53 — 蕇溊婉崘 | ||
| 53000 | 蕇溊婉崘 (INSUFFICIENT RESOURCES) | insufficient_resources |
| 53100 | 伕䕻悇 (DISK FULL) | disk_full |
| 53200 | 喙庻蔖儘 (OUT OF MEMORY) | out_of_memory |
| 53300 | 崻崔誂毖 (TOO MANY CONNECTIONS) | too_many_connections |
| 䌂 54 — 轙誺䘋废鍊彽 | ||
| 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 |
| 䌂 55 — 凹茇婉婘鵇噽襕挗䔇䪽攕 | ||
| 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 |
| 䌂 57 — 淉嘩蔙幾潬 | ||
| 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 |
| 䌂 58 — 係䂘髍臇(PostgreSQL 躻噌喙鄘䔇髍臇) | ||
| 58030 | IO 髍臇 (IO ERROR) | io_error |
| 58P01 | 橻垔幬䔇桺傽 (UNDEFINED FILE) | undefined_file |
| 58P02 | 麉崉䔇桺傽 (DUPLICATE FILE) | duplicate_file |
| 䌂 F0 — 陉䘞桺傽髍臇 | ||
| F0000 | 陉䘞桺傽髍臇 (CONFIG FILE ERROR) | config_file_error |
| F0001 | 髕桺傽庻婘 (LOCK FILE EXISTS) | lock_file_exists |
| 䌂 P0 — PL/pgSQL 髍臇 | ||
| P0000 | PLPGSQL 髍臇 (PLPGSQL ERROR) | plpgsql_error |
| P0001 | 檕庺嚗婩 (RAISE EXCEPTION) | raise_exception |
| P0002 | 橻欆彄昄扞 (NO DATA FOUND) | no_data_found |
| P0003 | 臯崻崔 (TOO MANY ROWS) | too_many_rows |
| 䌂 XX — 喙鄘髍臇 | ||
| XX000 | 喙鄘髍臇 (INTERNAL ERROR) | internal_error |
| XX001 | 昄扞托废 (DATA CORRUPTED) | data_corrupted |
| XX002 | 䘵嚘托废 (INDEX CORRUPTED) | index_corrupted |