public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected]
To: [email protected]
Subject: Table A-1. PostgreSQL Error Codes (WITH constants)
Date: Thu, 01 Dec 2005 13:31:56 -0200
Message-ID: <[email protected]> (raw)
For easy COPY/PASTE, here goes (attached) a revisised "Table A-1. PostgreSQL
Error Codes" with a new column "Constant".
Best Regards.
----------------------------------------------------------------
Mensagem enviada pelo Webmail UENF: http://www.grc.uenf.br/webmail
Attachments:
[text/html] TableA.htm (23.3K, 2-TableA.htm)
download | inline:
<table border="1">
<tr>
<td><b>Error Code</b></td>
<td><b>Meaning</b></td>
<td><b>Constant</b></td>
</tr>
<tr>
<td>Class 00</td>
<td>Successful Completion</td>
<td>
</td>
</tr>
<tr>
<td>0</td>
<td>SUCCESSFUL COMPLETION</td>
<td>successful_completion</td>
</tr>
<tr>
<td>Class 01</td>
<td>Warning</td>
<td> </td>
</tr>
<tr>
<td>1000</td>
<td>WARNING</td>
<td>warning</td>
</tr>
<tr>
<td>0100C</td>
<td>DYNAMIC RESULT SETS RETURNED</td>
<td>dynamic_result_sets_returned</td>
</tr>
<tr>
<td>1008</td>
<td>IMPLICIT ZERO BIT PADDING</td>
<td>implicit_zero_bit_padding</td>
</tr>
<tr>
<td>1003</td>
<td>NULL VALUE ELIMINATED IN SET FUNCTION</td>
<td>null_value_eliminated_in_set_function</td>
</tr>
<tr>
<td>1007</td>
<td>PRIVILEGE NOT GRANTED</td>
<td>privilege_not_granted</td>
</tr>
<tr>
<td>1006</td>
<td>PRIVILEGE NOT REVOKED</td>
<td>privilege_not_revoked</td>
</tr>
<tr>
<td>1004</td>
<td>STRING DATA RIGHT TRUNCATION</td>
<td>string_data_right_truncation</td>
</tr>
<tr>
<td>01P01</td>
<td>DEPRECATED FEATURE</td>
<td>deprecated_feature</td>
</tr>
<tr>
<td>Class 02</td>
<td>No Data — this is also a warning class per the SQL standard</td>
<td> </td>
</tr>
<tr>
<td>2000</td>
<td>NO DATA</td>
<td>no_data</td>
</tr>
<tr>
<td>2001</td>
<td>NO ADDITIONAL DYNAMIC RESULT SETS RETURNED</td>
<td>no_additional_dynamic_result_sets_returned</td>
</tr>
<tr>
<td>Class 03</td>
<td>SQL Statement Not Yet Complete</td>
<td> </td>
</tr>
<tr>
<td>3000</td>
<td>SQL STATEMENT NOT YET COMPLETE</td>
<td>sql_statement_not_yet_complete</td>
</tr>
<tr>
<td>Class 08</td>
<td>Connection Exception</td>
<td> </td>
</tr>
<tr>
<td>8000</td>
<td>CONNECTION EXCEPTION</td>
<td>connection_exception</td>
</tr>
<tr>
<td>8003</td>
<td>CONNECTION DOES NOT EXIST</td>
<td>connection_does_not_exist</td>
</tr>
<tr>
<td>8006</td>
<td>CONNECTION FAILURE</td>
<td>connection_failure</td>
</tr>
<tr>
<td>8001</td>
<td>SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION</td>
<td>sqlclient_unable_to_establish_sqlconnection</td>
</tr>
<tr>
<td>8004</td>
<td>SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION</td>
<td>sqlserver_rejected_establishment_of_sqlconnection</td>
</tr>
<tr>
<td>8007</td>
<td>TRANSACTION RESOLUTION UNKNOWN</td>
<td>transaction_resolution_unknown</td>
</tr>
<tr>
<td>08P01</td>
<td>PROTOCOL VIOLATION</td>
<td>protocol_violation</td>
</tr>
<tr>
<td>Class 09</td>
<td>Triggered Action Exception</td>
<td> </td>
</tr>
<tr>
<td>9000</td>
<td>TRIGGERED ACTION EXCEPTION</td>
<td>triggered_action_exception</td>
</tr>
<tr>
<td>Class 0A</td>
<td>Feature Not Supported</td>
<td> </td>
</tr>
<tr>
<td>0A000</td>
<td>FEATURE NOT SUPPORTED</td>
<td>feature_not_supported</td>
</tr>
<tr>
<td>Class 0B</td>
<td>Invalid Transaction Initiation</td>
<td> </td>
</tr>
<tr>
<td>0B000</td>
<td>INVALID TRANSACTION INITIATION</td>
<td>invalid_transaction_initiation</td>
</tr>
<tr>
<td>Class 0F</td>
<td>Locator Exception</td>
<td> </td>
</tr>
<tr>
<td>0F000</td>
<td>LOCATOR EXCEPTION</td>
<td>locator_exception</td>
</tr>
<tr>
<td>0F001</td>
<td>INVALID LOCATOR SPECIFICATION</td>
<td>invalid_locator_specification</td>
</tr>
<tr>
<td>Class 0L</td>
<td>Invalid Grantor</td>
<td> </td>
</tr>
<tr>
<td>0L000</td>
<td>INVALID GRANTOR</td>
<td>invalid_grantor</td>
</tr>
<tr>
<td>0LP01</td>
<td>INVALID GRANT OPERATION</td>
<td>invalid_grant_operation</td>
</tr>
<tr>
<td>Class 0P</td>
<td>Invalid Role Specification</td>
<td> </td>
</tr>
<tr>
<td>0P000</td>
<td>INVALID ROLE SPECIFICATION</td>
<td>invalid_role_specification</td>
</tr>
<tr>
<td>Class 21</td>
<td>Cardinality Violation</td>
<td> </td>
</tr>
<tr>
<td>21000</td>
<td>CARDINALITY VIOLATION</td>
<td>cardinality_violation</td>
</tr>
<tr>
<td>Class 22</td>
<td>Data Exception</td>
<td> </td>
</tr>
<tr>
<td>22000</td>
<td>DATA EXCEPTION</td>
<td>data_exception</td>
</tr>
<tr>
<td>2202E</td>
<td>ARRAY SUBSCRIPT ERROR</td>
<td>array_subscript_error</td>
</tr>
<tr>
<td>22021</td>
<td>CHARACTER NOT IN REPERTOIRE</td>
<td>character_not_in_repertoire</td>
</tr>
<tr>
<td>22008</td>
<td>DATETIME FIELD OVERFLOW</td>
<td>datetime_field_overflow</td>
</tr>
<tr>
<td>22012</td>
<td>DIVISION BY ZERO</td>
<td>division_by_zero</td>
</tr>
<tr>
<td>22005</td>
<td>ERROR IN ASSIGNMENT</td>
<td>error_in_assignment</td>
</tr>
<tr>
<td>2200B</td>
<td>ESCAPE CHARACTER CONFLICT</td>
<td>escape_character_conflict</td>
</tr>
<tr>
<td>22022</td>
<td>INDICATOR OVERFLOW</td>
<td>indicator_overflow</td>
</tr>
<tr>
<td>22015</td>
<td>INTERVAL FIELD OVERFLOW</td>
<td>interval_field_overflow</td>
</tr>
<tr>
<td>2201E</td>
<td>INVALID ARGUMENT FOR LOGARITHM</td>
<td>invalid_argument_for_logarithm</td>
</tr>
<tr>
<td>2201F</td>
<td>INVALID ARGUMENT FOR POWER FUNCTION</td>
<td>invalid_argument_for_power_function</td>
</tr>
<tr>
<td>2201G</td>
<td>INVALID ARGUMENT FOR WIDTH BUCKET FUNCTION</td>
<td>invalid_argument_for_width_bucket_function</td>
</tr>
<tr>
<td>22018</td>
<td>INVALID CHARACTER VALUE FOR CAST</td>
<td>invalid_character_value_for_cast</td>
</tr>
<tr>
<td>22007</td>
<td>INVALID DATETIME FORMAT</td>
<td>invalid_datetime_format</td>
</tr>
<tr>
<td>22019</td>
<td>INVALID ESCAPE CHARACTER</td>
<td>invalid_escape_character</td>
</tr>
<tr>
<td>2200D</td>
<td>INVALID ESCAPE OCTET</td>
<td>invalid_escape_octet</td>
</tr>
<tr>
<td>22025</td>
<td>INVALID ESCAPE SEQUENCE</td>
<td>invalid_escape_sequence</td>
</tr>
<tr>
<td>22P06</td>
<td>NONSTANDARD USE OF ESCAPE CHARACTER</td>
<td>nonstandard_use_of_escape_character</td>
</tr>
<tr>
<td>22010</td>
<td>INVALID INDICATOR PARAMETER VALUE</td>
<td>invalid_indicator_parameter_value</td>
</tr>
<tr>
<td>22020</td>
<td>INVALID LIMIT VALUE</td>
<td>invalid_limit_value</td>
</tr>
<tr>
<td>22023</td>
<td>INVALID PARAMETER VALUE</td>
<td>invalid_parameter_value</td>
</tr>
<tr>
<td>2201B</td>
<td>INVALID REGULAR EXPRESSION</td>
<td>invalid_regular_expression</td>
</tr>
<tr>
<td>22009</td>
<td>INVALID TIME ZONE DISPLACEMENT VALUE</td>
<td>invalid_time_zone_displacement_value</td>
</tr>
<tr>
<td>2200C</td>
<td>INVALID USE OF ESCAPE CHARACTER</td>
<td>invalid_use_of_escape_character</td>
</tr>
<tr>
<td>2200G</td>
<td>MOST SPECIFIC TYPE MISMATCH</td>
<td>most_specific_type_mismatch</td>
</tr>
<tr>
<td>22004</td>
<td>NULL VALUE NOT ALLOWED</td>
<td>null_value_not_allowed</td>
</tr>
<tr>
<td>22002</td>
<td>NULL VALUE NO INDICATOR PARAMETER</td>
<td>null_value_no_indicator_parameter</td>
</tr>
<tr>
<td>22003</td>
<td>NUMERIC VALUE OUT OF RANGE</td>
<td>numeric_value_out_of_range</td>
</tr>
<tr>
<td>22026</td>
<td>STRING DATA LENGTH MISMATCH</td>
<td>string_data_length_mismatch</td>
</tr>
<tr>
<td>22001</td>
<td>STRING DATA RIGHT TRUNCATION</td>
<td>string_data_right_truncation</td>
</tr>
<tr>
<td>22011</td>
<td>SUBSTRING ERROR</td>
<td>substring_error</td>
</tr>
<tr>
<td>22027</td>
<td>TRIM ERROR</td>
<td>trim_error</td>
</tr>
<tr>
<td>22024</td>
<td>UNTERMINATED C STRING</td>
<td>unterminated_c_string</td>
</tr>
<tr>
<td>2200F</td>
<td>ZERO LENGTH CHARACTER STRING</td>
<td>zero_length_character_string</td>
</tr>
<tr>
<td>22P01</td>
<td>FLOATING POINT EXCEPTION</td>
<td>floating_point_exception</td>
</tr>
<tr>
<td>22P02</td>
<td>INVALID TEXT REPRESENTATION</td>
<td>invalid_text_representation</td>
</tr>
<tr>
<td>22P03</td>
<td>INVALID BINARY REPRESENTATION</td>
<td>invalid_binary_representation</td>
</tr>
<tr>
<td>22P04</td>
<td>BAD COPY FILE FORMAT</td>
<td>bad_copy_file_format</td>
</tr>
<tr>
<td>22P05</td>
<td>UNTRANSLATABLE CHARACTER</td>
<td>untranslatable_character</td>
</tr>
<tr>
<td>Class 23</td>
<td>Integrity Constraint Violation</td>
<td> </td>
</tr>
<tr>
<td>23000</td>
<td>INTEGRITY CONSTRAINT VIOLATION</td>
<td>integrity_constraint_violation</td>
</tr>
<tr>
<td>23001</td>
<td>RESTRICT VIOLATION</td>
<td>restrict_violation</td>
</tr>
<tr>
<td>23502</td>
<td>NOT NULL VIOLATION</td>
<td>not_null_violation</td>
</tr>
<tr>
<td>23503</td>
<td>FOREIGN KEY VIOLATION</td>
<td>foreign_key_violation</td>
</tr>
<tr>
<td>23505</td>
<td>UNIQUE VIOLATION</td>
<td>unique_violation</td>
</tr>
<tr>
<td>23514</td>
<td>CHECK VIOLATION</td>
<td>check_violation</td>
</tr>
<tr>
<td>Class 24</td>
<td>Invalid Cursor State</td>
<td> </td>
</tr>
<tr>
<td>24000</td>
<td>INVALID CURSOR STATE</td>
<td>invalid_cursor_state</td>
</tr>
<tr>
<td>Class 25</td>
<td>Invalid Transaction State</td>
<td> </td>
</tr>
<tr>
<td>25000</td>
<td>INVALID TRANSACTION STATE</td>
<td>invalid_transaction_state</td>
</tr>
<tr>
<td>25001</td>
<td>ACTIVE SQL TRANSACTION</td>
<td>active_sql_transaction</td>
</tr>
<tr>
<td>25002</td>
<td>BRANCH TRANSACTION ALREADY ACTIVE</td>
<td>branch_transaction_already_active</td>
</tr>
<tr>
<td>25008</td>
<td>HELD CURSOR REQUIRES SAME ISOLATION LEVEL</td>
<td>held_cursor_requires_same_isolation_level</td>
</tr>
<tr>
<td>25003</td>
<td>INAPPROPRIATE ACCESS MODE FOR BRANCH TRANSACTION</td>
<td>inappropriate_access_mode_for_branch_transaction</td>
</tr>
<tr>
<td>25004</td>
<td>INAPPROPRIATE ISOLATION LEVEL FOR BRANCH TRANSACTION</td>
<td>inappropriate_isolation_level_for_branch_transaction</td>
</tr>
<tr>
<td>25005</td>
<td>NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION</td>
<td>no_active_sql_transaction_for_branch_transaction</td>
</tr>
<tr>
<td>25006</td>
<td>READ ONLY SQL TRANSACTION</td>
<td>read_only_sql_transaction</td>
</tr>
<tr>
<td>25007</td>
<td>SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED</td>
<td>schema_and_data_statement_mixing_not_supported</td>
</tr>
<tr>
<td>25P01</td>
<td>NO ACTIVE SQL TRANSACTION</td>
<td>no_active_sql_transaction</td>
</tr>
<tr>
<td>25P02</td>
<td>IN FAILED SQL TRANSACTION</td>
<td>in_failed_sql_transaction</td>
</tr>
<tr>
<td>Class 26</td>
<td>Invalid SQL Statement Name</td>
<td> </td>
</tr>
<tr>
<td>26000</td>
<td>INVALID SQL STATEMENT NAME</td>
<td>invalid_sql_statement_name</td>
</tr>
<tr>
<td>Class 27</td>
<td>Triggered Data Change Violation</td>
<td> </td>
</tr>
<tr>
<td>27000</td>
<td>TRIGGERED DATA CHANGE VIOLATION</td>
<td>triggered_data_change_violation</td>
</tr>
<tr>
<td>Class 28</td>
<td>Invalid Authorization Specification</td>
<td> </td>
</tr>
<tr>
<td>28000</td>
<td>INVALID AUTHORIZATION SPECIFICATION</td>
<td>invalid_authorization_specification</td>
</tr>
<tr>
<td>Class 2B</td>
<td>Dependent Privilege Descriptors Still Exist</td>
<td> </td>
</tr>
<tr>
<td>2B000</td>
<td>DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST</td>
<td>dependent_privilege_descriptors_still_exist</td>
</tr>
<tr>
<td>2BP01</td>
<td>DEPENDENT OBJECTS STILL EXIST</td>
<td>dependent_objects_still_exist</td>
</tr>
<tr>
<td>Class 2D</td>
<td>Invalid Transaction Termination</td>
<td> </td>
</tr>
<tr>
<td>2D000</td>
<td>INVALID TRANSACTION TERMINATION</td>
<td>invalid_transaction_termination</td>
</tr>
<tr>
<td>Class 2F</td>
<td>SQL Routine Exception</td>
<td> </td>
</tr>
<tr>
<td>2F000</td>
<td>SQL ROUTINE EXCEPTION</td>
<td>sql_routine_exception</td>
</tr>
<tr>
<td>2F005</td>
<td>FUNCTION EXECUTED NO RETURN STATEMENT</td>
<td>function_executed_no_return_statement</td>
</tr>
<tr>
<td>2F002</td>
<td>MODIFYING SQL DATA NOT PERMITTED</td>
<td>modifying_sql_data_not_permitted</td>
</tr>
<tr>
<td>2F003</td>
<td>PROHIBITED SQL STATEMENT ATTEMPTED</td>
<td>prohibited_sql_statement_attempted</td>
</tr>
<tr>
<td>2F004</td>
<td>READING SQL DATA NOT PERMITTED</td>
<td>reading_sql_data_not_permitted</td>
</tr>
<tr>
<td>Class 34</td>
<td>Invalid Cursor Name</td>
<td> </td>
</tr>
<tr>
<td>34000</td>
<td>INVALID CURSOR NAME</td>
<td>invalid_cursor_name</td>
</tr>
<tr>
<td>Class 38</td>
<td>External Routine Exception</td>
<td> </td>
</tr>
<tr>
<td>38000</td>
<td>EXTERNAL ROUTINE EXCEPTION</td>
<td>external_routine_exception</td>
</tr>
<tr>
<td>38001</td>
<td>CONTAINING SQL NOT PERMITTED</td>
<td>containing_sql_not_permitted</td>
</tr>
<tr>
<td>38002</td>
<td>MODIFYING SQL DATA NOT PERMITTED</td>
<td>modifying_sql_data_not_permitted</td>
</tr>
<tr>
<td>38003</td>
<td>PROHIBITED SQL STATEMENT ATTEMPTED</td>
<td>prohibited_sql_statement_attempted</td>
</tr>
<tr>
<td>38004</td>
<td>READING SQL DATA NOT PERMITTED</td>
<td>reading_sql_data_not_permitted</td>
</tr>
<tr>
<td>Class 39</td>
<td>External Routine Invocation Exception</td>
<td> </td>
</tr>
<tr>
<td>39000</td>
<td>EXTERNAL ROUTINE INVOCATION EXCEPTION</td>
<td>external_routine_invocation_exception</td>
</tr>
<tr>
<td>39001</td>
<td>INVALID SQLSTATE RETURNED</td>
<td>invalid_sqlstate_returned</td>
</tr>
<tr>
<td>39004</td>
<td>NULL VALUE NOT ALLOWED</td>
<td>null_value_not_allowed</td>
</tr>
<tr>
<td>39P01</td>
<td>TRIGGER PROTOCOL VIOLATED</td>
<td>trigger_protocol_violated</td>
</tr>
<tr>
<td>39P02</td>
<td>SRF PROTOCOL VIOLATED</td>
<td>srf_protocol_violated</td>
</tr>
<tr>
<td>Class 3B</td>
<td>Savepoint Exception</td>
<td> </td>
</tr>
<tr>
<td>3B000</td>
<td>SAVEPOINT EXCEPTION</td>
<td>savepoint_exception</td>
</tr>
<tr>
<td>3B001</td>
<td>INVALID SAVEPOINT SPECIFICATION</td>
<td>invalid_savepoint_specification</td>
</tr>
<tr>
<td>Class 3D</td>
<td>Invalid Catalog Name</td>
<td> </td>
</tr>
<tr>
<td>3D000</td>
<td>INVALID CATALOG NAME</td>
<td>invalid_catalog_name</td>
</tr>
<tr>
<td>Class 3F</td>
<td>Invalid Schema Name</td>
<td> </td>
</tr>
<tr>
<td>3F000</td>
<td>INVALID SCHEMA NAME</td>
<td>invalid_schema_name</td>
</tr>
<tr>
<td>Class 40</td>
<td>Transaction Rollback</td>
<td> </td>
</tr>
<tr>
<td>40000</td>
<td>TRANSACTION ROLLBACK</td>
<td>transaction_rollback</td>
</tr>
<tr>
<td>40002</td>
<td>TRANSACTION INTEGRITY CONSTRAINT VIOLATION</td>
<td>transaction_integrity_constraint_violation</td>
</tr>
<tr>
<td>40001</td>
<td>SERIALIZATION FAILURE</td>
<td>serialization_failure</td>
</tr>
<tr>
<td>40003</td>
<td>STATEMENT COMPLETION UNKNOWN</td>
<td>statement_completion_unknown</td>
</tr>
<tr>
<td>40P01</td>
<td>DEADLOCK DETECTED</td>
<td>deadlock_detected</td>
</tr>
<tr>
<td>Class 42</td>
<td>Syntax Error or Access Rule Violation</td>
<td> </td>
</tr>
<tr>
<td>42000</td>
<td>SYNTAX ERROR OR ACCESS RULE VIOLATION</td>
<td>syntax_error_or_access_rule_violation</td>
</tr>
<tr>
<td>42601</td>
<td>SYNTAX ERROR</td>
<td>syntax_error</td>
</tr>
<tr>
<td>42501</td>
<td>INSUFFICIENT PRIVILEGE</td>
<td>insufficient_privilege</td>
</tr>
<tr>
<td>42846</td>
<td>CANNOT COERCE</td>
<td>cannot_coerce</td>
</tr>
<tr>
<td>42803</td>
<td>GROUPING ERROR</td>
<td>grouping_error</td>
</tr>
<tr>
<td>42830</td>
<td>INVALID FOREIGN KEY</td>
<td>invalid_foreign_key</td>
</tr>
<tr>
<td>42602</td>
<td>INVALID NAME</td>
<td>invalid_name</td>
</tr>
<tr>
<td>42622</td>
<td>NAME TOO LONG</td>
<td>name_too_long</td>
</tr>
<tr>
<td>42939</td>
<td>RESERVED NAME</td>
<td>reserved_name</td>
</tr>
<tr>
<td>42804</td>
<td>DATATYPE MISMATCH</td>
<td>datatype_mismatch</td>
</tr>
<tr>
<td>42P18</td>
<td>INDETERMINATE DATATYPE</td>
<td>indeterminate_datatype</td>
</tr>
<tr>
<td>42809</td>
<td>WRONG OBJECT TYPE</td>
<td>wrong_object_type</td>
</tr>
<tr>
<td>42703</td>
<td>UNDEFINED COLUMN</td>
<td>undefined_column</td>
</tr>
<tr>
<td>42883</td>
<td>UNDEFINED FUNCTION</td>
<td>undefined_function</td>
</tr>
<tr>
<td>42P01</td>
<td>UNDEFINED TABLE</td>
<td>undefined_table</td>
</tr>
<tr>
<td>42P02</td>
<td>UNDEFINED PARAMETER</td>
<td>undefined_parameter</td>
</tr>
<tr>
<td>42704</td>
<td>UNDEFINED OBJECT</td>
<td>undefined_object</td>
</tr>
<tr>
<td>42701</td>
<td>DUPLICATE COLUMN</td>
<td>duplicate_column</td>
</tr>
<tr>
<td>42P03</td>
<td>DUPLICATE CURSOR</td>
<td>duplicate_cursor</td>
</tr>
<tr>
<td>42P04</td>
<td>DUPLICATE DATABASE</td>
<td>duplicate_database</td>
</tr>
<tr>
<td>42723</td>
<td>DUPLICATE FUNCTION</td>
<td>duplicate_function</td>
</tr>
<tr>
<td>42P05</td>
<td>DUPLICATE PREPARED STATEMENT</td>
<td>duplicate_prepared_statement</td>
</tr>
<tr>
<td>42P06</td>
<td>DUPLICATE SCHEMA</td>
<td>duplicate_schema</td>
</tr>
<tr>
<td>42P07</td>
<td>DUPLICATE TABLE</td>
<td>duplicate_table</td>
</tr>
<tr>
<td>42712</td>
<td>DUPLICATE ALIAS</td>
<td>duplicate_alias</td>
</tr>
<tr>
<td>42710</td>
<td>DUPLICATE OBJECT</td>
<td>duplicate_object</td>
</tr>
<tr>
<td>42702</td>
<td>AMBIGUOUS COLUMN</td>
<td>ambiguous_column</td>
</tr>
<tr>
<td>42725</td>
<td>AMBIGUOUS FUNCTION</td>
<td>ambiguous_function</td>
</tr>
<tr>
<td>42P08</td>
<td>AMBIGUOUS PARAMETER</td>
<td>ambiguous_parameter</td>
</tr>
<tr>
<td>42P09</td>
<td>AMBIGUOUS ALIAS</td>
<td>ambiguous_alias</td>
</tr>
<tr>
<td>42P10</td>
<td>INVALID COLUMN REFERENCE</td>
<td>invalid_column_reference</td>
</tr>
<tr>
<td>42611</td>
<td>INVALID COLUMN DEFINITION</td>
<td>invalid_column_definition</td>
</tr>
<tr>
<td>42P11</td>
<td>INVALID CURSOR DEFINITION</td>
<td>invalid_cursor_definition</td>
</tr>
<tr>
<td>42P12</td>
<td>INVALID DATABASE DEFINITION</td>
<td>invalid_database_definition</td>
</tr>
<tr>
<td>42P13</td>
<td>INVALID FUNCTION DEFINITION</td>
<td>invalid_function_definition</td>
</tr>
<tr>
<td>42P14</td>
<td>INVALID PREPARED STATEMENT DEFINITION</td>
<td>invalid_prepared_statement_definition</td>
</tr>
<tr>
<td>42P15</td>
<td>INVALID SCHEMA DEFINITION</td>
<td>invalid_schema_definition</td>
</tr>
<tr>
<td>42P16</td>
<td>INVALID TABLE DEFINITION</td>
<td>invalid_table_definition</td>
</tr>
<tr>
<td>42P17</td>
<td>INVALID OBJECT DEFINITION</td>
<td>invalid_object_definition</td>
</tr>
<tr>
<td>Class 44</td>
<td>WITH CHECK OPTION Violation</td>
<td> </td>
</tr>
<tr>
<td>44000</td>
<td>WITH CHECK OPTION VIOLATION</td>
<td>with_check_option_violation</td>
</tr>
<tr>
<td>Class 53</td>
<td>Insufficient Resources</td>
<td> </td>
</tr>
<tr>
<td>53000</td>
<td>INSUFFICIENT RESOURCES</td>
<td>insufficient_resources</td>
</tr>
<tr>
<td>53100</td>
<td>DISK FULL</td>
<td>disk_full</td>
</tr>
<tr>
<td>53200</td>
<td>OUT OF MEMORY</td>
<td>out_of_memory</td>
</tr>
<tr>
<td>53300</td>
<td>TOO MANY CONNECTIONS</td>
<td>too_many_connections</td>
</tr>
<tr>
<td>Class 54</td>
<td>Program Limit Exceeded</td>
<td> </td>
</tr>
<tr>
<td>54000</td>
<td>PROGRAM LIMIT EXCEEDED</td>
<td>program_limit_exceeded</td>
</tr>
<tr>
<td>54001</td>
<td>STATEMENT TOO COMPLEX</td>
<td>statement_too_complex</td>
</tr>
<tr>
<td>54011</td>
<td>TOO MANY COLUMNS</td>
<td>too_many_columns</td>
</tr>
<tr>
<td>54023</td>
<td>TOO MANY ARGUMENTS</td>
<td>too_many_arguments</td>
</tr>
<tr>
<td>Class 55</td>
<td>Object Not In Prerequisite State</td>
<td> </td>
</tr>
<tr>
<td>55000</td>
<td>OBJECT NOT IN PREREQUISITE STATE</td>
<td>object_not_in_prerequisite_state</td>
</tr>
<tr>
<td>55006</td>
<td>OBJECT IN USE</td>
<td>object_in_use</td>
</tr>
<tr>
<td>55P02</td>
<td>CANT CHANGE RUNTIME PARAM</td>
<td>cant_change_runtime_param</td>
</tr>
<tr>
<td>55P03</td>
<td>LOCK NOT AVAILABLE</td>
<td>lock_not_available</td>
</tr>
<tr>
<td>Class 57</td>
<td>Operator Intervention</td>
<td> </td>
</tr>
<tr>
<td>57000</td>
<td>OPERATOR INTERVENTION</td>
<td>operator_intervention</td>
</tr>
<tr>
<td>57014</td>
<td>QUERY CANCELED</td>
<td>query_canceled</td>
</tr>
<tr>
<td>57P01</td>
<td>ADMIN SHUTDOWN</td>
<td>admin_shutdown</td>
</tr>
<tr>
<td>57P02</td>
<td>CRASH SHUTDOWN</td>
<td>crash_shutdown</td>
</tr>
<tr>
<td>57P03</td>
<td>CANNOT CONNECT NOW</td>
<td>cannot_connect_now</td>
</tr>
<tr>
<td>Class 58</td>
<td>System Error (errors external to PostgreSQL itself)</td>
<td> </td>
</tr>
<tr>
<td>58030</td>
<td>IO ERROR</td>
<td>io_error</td>
</tr>
<tr>
<td>58P01</td>
<td>UNDEFINED FILE</td>
<td>undefined_file</td>
</tr>
<tr>
<td>58P02</td>
<td>DUPLICATE FILE</td>
<td>duplicate_file</td>
</tr>
<tr>
<td>Class F0</td>
<td>Configuration File Error</td>
<td> </td>
</tr>
<tr>
<td>F0000</td>
<td>CONFIG FILE ERROR</td>
<td>config_file_error</td>
</tr>
<tr>
<td>F0001</td>
<td>LOCK FILE EXISTS</td>
<td>lock_file_exists</td>
</tr>
<tr>
<td>Class P0</td>
<td>PL/pgSQL Error</td>
<td> </td>
</tr>
<tr>
<td>P0000</td>
<td>PLPGSQL ERROR</td>
<td>plpgsql_error</td>
</tr>
<tr>
<td>P0001</td>
<td>RAISE EXCEPTION</td>
<td>raise_exception</td>
</tr>
<tr>
<td>Class XX</td>
<td>Internal Error</td>
<td> </td>
</tr>
<tr>
<td>XX000</td>
<td>INTERNAL ERROR</td>
<td>internal_error</td>
</tr>
<tr>
<td>XX001</td>
<td>DATA CORRUPTED</td>
<td>data_corrupted</td>
</tr>
<tr>
<td>XX002</td>
<td>INDEX CORRUPTED</td>
<td>index_corrupted</td>
</tr>
</table>
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Table A-1. PostgreSQL Error Codes (WITH constants)
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox