errcodes.sgml

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 28&mdash; Invalid Authorization Specification</></entry>
</row>

<row>
<entry>28000</entry>
<entry>INVALID AUTHORIZATION SPECIFICATION</entry>
<entry>invalid_authorization_specification</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 2B&mdash; Dependent Privilege Descriptors Still Exist</></entry>
</row>

<row>
<entry>2B000</entry>
<entry>DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST</entry>
<entry>dependent_privilege_descriptors_still_exist</entry>
</row>

<row>
<entry>2BP01</entry>
<entry>DEPENDENT OBJECTS STILL EXIST</entry>
<entry>dependent_objects_still_exist</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 2D&mdash; Invalid Transaction Termination</></entry>
</row>

<row>
<entry>2D000</entry>
<entry>INVALID TRANSACTION TERMINATION</entry>
<entry>invalid_transaction_termination</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 2F&mdash; SQL Routine Exception</></entry>
</row>

<row>
<entry>2F000</entry>
<entry>SQL ROUTINE EXCEPTION</entry>
<entry>sql_routine_exception</entry>
</row>

<row>
<entry>2F005</entry>
<entry>FUNCTION EXECUTED NO RETURN STATEMENT</entry>
<entry>function_executed_no_return_statement</entry>
</row>

<row>
<entry>2F002</entry>
<entry>MODIFYING SQL DATA NOT PERMITTED</entry>
<entry>modifying_sql_data_not_permitted</entry>
</row>

<row>
<entry>2F003</entry>
<entry>PROHIBITED SQL STATEMENT ATTEMPTED</entry>
<entry>prohibited_sql_statement_attempted</entry>
</row>

<row>
<entry>2F004</entry>
<entry>READING SQL DATA NOT PERMITTED</entry>
<entry>reading_sql_data_not_permitted</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 34&mdash; Invalid Cursor Name</></entry>
</row>

<row>
<entry>34000</entry>
<entry>INVALID CURSOR NAME</entry>
<entry>invalid_cursor_name</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 38&mdash; External Routine Exception</></entry>
</row>

<row>
<entry>38000</entry>
<entry>EXTERNAL ROUTINE EXCEPTION</entry>
<entry>external_routine_exception</entry>
</row>

<row>
<entry>38001</entry>
<entry>CONTAINING SQL NOT PERMITTED</entry>
<entry>containing_sql_not_permitted</entry>
</row>

<row>
<entry>38002</entry>
<entry>MODIFYING SQL DATA NOT PERMITTED</entry>
<entry>modifying_sql_data_not_permitted</entry>
</row>

<row>
<entry>38003</entry>
<entry>PROHIBITED SQL STATEMENT ATTEMPTED</entry>
<entry>prohibited_sql_statement_attempted</entry>
</row>

<row>
<entry>38004</entry>
<entry>READING SQL DATA NOT PERMITTED</entry>
<entry>reading_sql_data_not_permitted</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 39&mdash; External Routine Invocation Exception</></entry>
</row>

<row>
<entry>39000</entry>
<entry>EXTERNAL ROUTINE INVOCATION EXCEPTION</entry>
<entry>external_routine_invocation_exception</entry>
</row>

<row>
<entry>39001</entry>
<entry>INVALID SQLSTATE RETURNED</entry>
<entry>invalid_sqlstate_returned</entry>
</row>

<row>
<entry>39004</entry>
<entry>NULL VALUE NOT ALLOWED</entry>
<entry>null_value_not_allowed</entry>
</row>

<row>
<entry>39P01</entry>
<entry>TRIGGER PROTOCOL VIOLATED</entry>
<entry>trigger_protocol_violated</entry>
</row>

<row>
<entry>39P02</entry>
<entry>SRF PROTOCOL VIOLATED</entry>
<entry>srf_protocol_violated</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 3B&mdash; Savepoint Exception</></entry>
</row>

<row>
<entry>3B000</entry>
<entry>SAVEPOINT EXCEPTION</entry>
<entry>savepoint_exception</entry>
</row>

<row>
<entry>3B001</entry>
<entry>INVALID SAVEPOINT SPECIFICATION</entry>
<entry>invalid_savepoint_specification</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 3D&mdash; Invalid Catalog Name</></entry>
</row>

<row>
<entry>3D000</entry>
<entry>INVALID CATALOG NAME</entry>
<entry>invalid_catalog_name</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 3F&mdash; Invalid Schema Name</></entry>
</row>

<row>
<entry>3F000</entry>
<entry>INVALID SCHEMA NAME</entry>
<entry>invalid_schema_name</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 40&mdash; Transaction Rollback</></entry>
</row>

<row>
<entry>40000</entry>
<entry>TRANSACTION ROLLBACK</entry>
<entry>transaction_rollback</entry>
</row>

<row>
<entry>40002</entry>
<entry>TRANSACTION INTEGRITY CONSTRAINT VIOLATION</entry>
<entry>transaction_integrity_constraint_violation</entry>
</row>

<row>
<entry>40001</entry>
<entry>SERIALIZATION FAILURE</entry>
<entry>serialization_failure</entry>
</row>

<row>
<entry>40003</entry>
<entry>STATEMENT COMPLETION UNKNOWN</entry>
<entry>statement_completion_unknown</entry>
</row>

<row>
<entry>40P01</entry>
<entry>DEADLOCK DETECTED</entry>
<entry>deadlock_detected</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 42&mdash; Syntax Error or Access Rule Violation</></entry>
</row>

<row>
<entry>42000</entry>
<entry>SYNTAX ERROR OR ACCESS RULE VIOLATION</entry>
<entry>syntax_error_or_access_rule_violation</entry>
</row>

<row>
<entry>42601</entry>
<entry>SYNTAX ERROR</entry>
<entry>syntax_error</entry>
</row>

<row>
<entry>42501</entry>
<entry>INSUFFICIENT PRIVILEGE</entry>
<entry>insufficient_privilege</entry>
</row>

<row>
<entry>42846</entry>
<entry>CANNOT COERCE</entry>
<entry>cannot_coerce</entry>
</row>

<row>
<entry>42803</entry>
<entry>GROUPING ERROR</entry>
<entry>grouping_error</entry>
</row>

<row>
<entry>42830</entry>
<entry>INVALID FOREIGN KEY</entry>
<entry>invalid_foreign_key</entry>
</row>

<row>
<entry>42602</entry>
<entry>INVALID NAME</entry>
<entry>invalid_name</entry>
</row>

<row>
<entry>42622</entry>
<entry>NAME TOO LONG</entry>
<entry>name_too_long</entry>
</row>

<row>
<entry>42939</entry>
<entry>RESERVED NAME</entry>
<entry>reserved_name</entry>
</row>

<row>
<entry>42804</entry>
<entry>DATATYPE MISMATCH</entry>
<entry>datatype_mismatch</entry>
</row>

<row>
<entry>42P18</entry>
<entry>INDETERMINATE DATATYPE</entry>
<entry>indeterminate_datatype</entry>
</row>

<row>
<entry>42809</entry>
<entry>WRONG OBJECT TYPE</entry>
<entry>wrong_object_type</entry>
</row>

<row>
<entry>42703</entry>
<entry>UNDEFINED COLUMN</entry>
<entry>undefined_column</entry>
</row>

<row>
<entry>42883</entry>
<entry>UNDEFINED FUNCTION</entry>
<entry>undefined_function</entry>
</row>

<row>
<entry>42P01</entry>
<entry>UNDEFINED TABLE</entry>
<entry>undefined_table</entry>
</row>

<row>
<entry>42P02</entry>
<entry>UNDEFINED PARAMETER</entry>
<entry>undefined_parameter</entry>
</row>

<row>
<entry>42704</entry>
<entry>UNDEFINED OBJECT</entry>
<entry>undefined_object</entry>
</row>

<row>
<entry>42701</entry>
<entry>DUPLICATE COLUMN</entry>
<entry>duplicate_column</entry>
</row>

<row>
<entry>42P03</entry>
<entry>DUPLICATE CURSOR</entry>
<entry>duplicate_cursor</entry>
</row>

<row>
<entry>42P04</entry>
<entry>DUPLICATE DATABASE</entry>
<entry>duplicate_database</entry>
</row>

<row>
<entry>42723</entry>
<entry>DUPLICATE FUNCTION</entry>
<entry>duplicate_function</entry>
</row>

<row>
<entry>42P05</entry>
<entry>DUPLICATE PREPARED STATEMENT</entry>
<entry>duplicate_prepared_statement</entry>
</row>

<row>
<entry>42P06</entry>
<entry>DUPLICATE SCHEMA</entry>
<entry>duplicate_schema</entry>
</row>

<row>
<entry>42P07</entry>
<entry>DUPLICATE TABLE</entry>
<entry>duplicate_table</entry>
</row>

<row>
<entry>42712</entry>
<entry>DUPLICATE ALIAS</entry>
<entry>duplicate_alias</entry>
</row>

<row>
<entry>42710</entry>
<entry>DUPLICATE OBJECT</entry>
<entry>duplicate_object</entry>
</row>

<row>
<entry>42702</entry>
<entry>AMBIGUOUS COLUMN</entry>
<entry>ambiguous_column</entry>
</row>

<row>
<entry>42725</entry>
<entry>AMBIGUOUS FUNCTION</entry>
<entry>ambiguous_function</entry>
</row>

<row>
<entry>42P08</entry>
<entry>AMBIGUOUS PARAMETER</entry>
<entry>ambiguous_parameter</entry>
</row>

<row>
<entry>42P09</entry>
<entry>AMBIGUOUS ALIAS</entry>
<entry>ambiguous_alias</entry>
</row>

<row>
<entry>42P10</entry>
<entry>INVALID COLUMN REFERENCE</entry>
<entry>invalid_column_reference</entry>
</row>

<row>
<entry>42611</entry>
<entry>INVALID COLUMN DEFINITION</entry>
<entry>invalid_column_definition</entry>
</row>

<row>
<entry>42P11</entry>
<entry>INVALID CURSOR DEFINITION</entry>
<entry>invalid_cursor_definition</entry>
</row>

<row>
<entry>42P12</entry>
<entry>INVALID DATABASE DEFINITION</entry>
<entry>invalid_database_definition</entry>
</row>

<row>
<entry>42P13</entry>
<entry>INVALID FUNCTION DEFINITION</entry>
<entry>invalid_function_definition</entry>
</row>

<row>
<entry>42P14</entry>
<entry>INVALID PREPARED STATEMENT DEFINITION</entry>
<entry>invalid_prepared_statement_definition</entry>
</row>

<row>
<entry>42P15</entry>
<entry>INVALID SCHEMA DEFINITION</entry>
<entry>invalid_schema_definition</entry>
</row>

<row>
<entry>42P16</entry>
<entry>INVALID TABLE DEFINITION</entry>
<entry>invalid_table_definition</entry>
</row>

<row>
<entry>42P17</entry>
<entry>INVALID OBJECT DEFINITION</entry>
<entry>invalid_object_definition</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 44&mdash; WITH CHECK OPTION Violation</></entry>
</row>

<row>
<entry>44000</entry>
<entry>WITH CHECK OPTION VIOLATION</entry>
<entry>with_check_option_violation</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 53&mdash; Insufficient Resources</></entry>
</row>

<row>
<entry>53000</entry>
<entry>INSUFFICIENT RESOURCES</entry>
<entry>insufficient_resources</entry>
</row>

<row>
<entry>53100</entry>
<entry>DISK FULL</entry>
<entry>disk_full</entry>
</row>

<row>
<entry>53200</entry>
<entry>OUT OF MEMORY</entry>
<entry>out_of_memory</entry>
</row>

<row>
<entry>53300</entry>
<entry>TOO MANY CONNECTIONS</entry>
<entry>too_many_connections</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 54&mdash; Program Limit Exceeded</></entry>
</row>

<row>
<entry>54000</entry>
<entry>PROGRAM LIMIT EXCEEDED</entry>
<entry>program_limit_exceeded</entry>
</row>

<row>
<entry>54001</entry>
<entry>STATEMENT TOO COMPLEX</entry>
<entry>statement_too_complex</entry>
</row>

<row>
<entry>54011</entry>
<entry>TOO MANY COLUMNS</entry>
<entry>too_many_columns</entry>
</row>

<row>
<entry>54023</entry>
<entry>TOO MANY ARGUMENTS</entry>
<entry>too_many_arguments</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 55&mdash; Object Not In Prerequisite State</></entry>
</row>

<row>
<entry>55000</entry>
<entry>OBJECT NOT IN PREREQUISITE STATE</entry>
<entry>object_not_in_prerequisite_state</entry>
</row>

<row>
<entry>55006</entry>
<entry>OBJECT IN USE</entry>
<entry>object_in_use</entry>
</row>

<row>
<entry>55P02</entry>
<entry>CANT CHANGE RUNTIME PARAM</entry>
<entry>cant_change_runtime_param</entry>
</row>

<row>
<entry>55P03</entry>
<entry>LOCK NOT AVAILABLE</entry>
<entry>lock_not_available</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 57&mdash; Operator Intervention</></entry>
</row>

<row>
<entry>57000</entry>
<entry>OPERATOR INTERVENTION</entry>
<entry>operator_intervention</entry>
</row>

<row>
<entry>57014</entry>
<entry>QUERY CANCELED</entry>
<entry>query_canceled</entry>
</row>

<row>
<entry>57P01</entry>
<entry>ADMIN SHUTDOWN</entry>
<entry>admin_shutdown</entry>
</row>

<row>
<entry>57P02</entry>
<entry>CRASH SHUTDOWN</entry>
<entry>crash_shutdown</entry>
</row>

<row>
<entry>57P03</entry>
<entry>CANNOT CONNECT NOW</entry>
<entry>cannot_connect_now</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class 58&mdash; System Error (errors external to PostgreSQL itself)</></entry>
</row>

<row>
<entry>58030</entry>
<entry>IO ERROR</entry>
<entry>io_error</entry>
</row>

<row>
<entry>58P01</entry>
<entry>UNDEFINED FILE</entry>
<entry>undefined_file</entry>
</row>

<row>
<entry>58P02</entry>
<entry>DUPLICATE FILE</entry>
<entry>duplicate_file</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class F0&mdash; Configuration File Error</></entry>
</row>

<row>
<entry>F0000</entry>
<entry>CONFIG FILE ERROR</entry>
<entry>config_file_error</entry>
</row>

<row>
<entry>F0001</entry>
<entry>LOCK FILE EXISTS</entry>
<entry>lock_file_exists</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class P0&mdash; PL/pgSQL Error</></entry>
</row>

<row>
<entry>P0000</entry>
<entry>PLPGSQL ERROR</entry>
<entry>plpgsql_error</entry>
</row>

<row>
<entry>P0001</entry>
<entry>RAISE EXCEPTION</entry>
<entry>raise_exception</entry>
</row>

<row>
<entry spanname="span13"><emphasis role="bold">Class XX&mdash; Internal Error</></entry>
</row>

<row>
<entry>XX000</entry>
<entry>INTERNAL ERROR</entry>
<entry>internal_error</entry>
</row>

<row>
<entry>XX001</entry>
<entry>DATA CORRUPTED</entry>
<entry>data_corrupted</entry>
</row>

<row>
<entry>XX002</entry>
<entry>INDEX CORRUPTED</entry>
<entry>index_corrupted</entry>
</row>

  </tbody>
 </tgroup>
</table>


</appendix>