1 /*-------------------------------------------------------------------------
4 * PL/pgSQL error codes (mapping of exception labels to SQLSTATEs)
6 * Eventually this header file should be auto-generated from errcodes.h
7 * with some sort of sed hackery, but no time for that now. It's likely
8 * that an exact mapping will not be what's wanted anyhow ...
10 * Copyright (c) 2003-2005, PostgreSQL Global Development Group
12 * $PostgreSQL: pgsql/src/pl/plpgsql/src/plerrcodes.h,v 1.6 2005/01/01 20:44:32 tgl Exp $
14 *-------------------------------------------------------------------------
17 /* Success and warnings can't be caught, so omit them from table */
19 "sql_statement_not_yet_complete", ERRCODE_SQL_STATEMENT_NOT_YET_COMPLETE
23 "connection_exception", ERRCODE_CONNECTION_EXCEPTION
27 "connection_does_not_exist", ERRCODE_CONNECTION_DOES_NOT_EXIST
31 "connection_failure", ERRCODE_CONNECTION_FAILURE
35 "sqlclient_unable_to_establish_sqlconnection", ERRCODE_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION
39 "sqlserver_rejected_establishment_of_sqlconnection", ERRCODE_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION
43 "transaction_resolution_unknown", ERRCODE_TRANSACTION_RESOLUTION_UNKNOWN
47 "protocol_violation", ERRCODE_PROTOCOL_VIOLATION
51 "triggered_action_exception", ERRCODE_TRIGGERED_ACTION_EXCEPTION
55 "feature_not_supported", ERRCODE_FEATURE_NOT_SUPPORTED
59 "invalid_transaction_initiation", ERRCODE_INVALID_TRANSACTION_INITIATION
63 "locator_exception", ERRCODE_LOCATOR_EXCEPTION
67 "invalid_locator_specification", ERRCODE_L_E_INVALID_SPECIFICATION
71 "invalid_grantor", ERRCODE_INVALID_GRANTOR
75 "invalid_grant_operation", ERRCODE_INVALID_GRANT_OPERATION
79 "invalid_role_specification", ERRCODE_INVALID_ROLE_SPECIFICATION
83 "cardinality_violation", ERRCODE_CARDINALITY_VIOLATION
87 "data_exception", ERRCODE_DATA_EXCEPTION
91 "array_element_error", ERRCODE_ARRAY_ELEMENT_ERROR
95 "array_subscript_error", ERRCODE_ARRAY_SUBSCRIPT_ERROR
99 "character_not_in_repertoire", ERRCODE_CHARACTER_NOT_IN_REPERTOIRE
103 "datetime_field_overflow", ERRCODE_DATETIME_FIELD_OVERFLOW
107 "datetime_value_out_of_range", ERRCODE_DATETIME_VALUE_OUT_OF_RANGE
111 "division_by_zero", ERRCODE_DIVISION_BY_ZERO
115 "error_in_assignment", ERRCODE_ERROR_IN_ASSIGNMENT
119 "escape_character_conflict", ERRCODE_ESCAPE_CHARACTER_CONFLICT
123 "indicator_overflow", ERRCODE_INDICATOR_OVERFLOW
127 "interval_field_overflow", ERRCODE_INTERVAL_FIELD_OVERFLOW
131 "invalid_argument_for_logarithm", ERRCODE_INVALID_ARGUMENT_FOR_LOG
135 "invalid_argument_for_power_function", ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION
139 "invalid_argument_for_width_bucket_function", ERRCODE_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION
143 "invalid_character_value_for_cast", ERRCODE_INVALID_CHARACTER_VALUE_FOR_CAST
147 "invalid_datetime_format", ERRCODE_INVALID_DATETIME_FORMAT
151 "invalid_escape_character", ERRCODE_INVALID_ESCAPE_CHARACTER
155 "invalid_escape_octet", ERRCODE_INVALID_ESCAPE_OCTET
159 "invalid_escape_sequence", ERRCODE_INVALID_ESCAPE_SEQUENCE
163 "invalid_indicator_parameter_value", ERRCODE_INVALID_INDICATOR_PARAMETER_VALUE
167 "invalid_limit_value", ERRCODE_INVALID_LIMIT_VALUE
171 "invalid_parameter_value", ERRCODE_INVALID_PARAMETER_VALUE
175 "invalid_regular_expression", ERRCODE_INVALID_REGULAR_EXPRESSION
179 "invalid_time_zone_displacement_value", ERRCODE_INVALID_TIME_ZONE_DISPLACEMENT_VALUE
183 "invalid_use_of_escape_character", ERRCODE_INVALID_USE_OF_ESCAPE_CHARACTER
187 "most_specific_type_mismatch", ERRCODE_MOST_SPECIFIC_TYPE_MISMATCH
191 "null_value_not_allowed", ERRCODE_NULL_VALUE_NOT_ALLOWED
195 "null_value_no_indicator_parameter", ERRCODE_NULL_VALUE_NO_INDICATOR_PARAMETER
199 "numeric_value_out_of_range", ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE
203 "string_data_length_mismatch", ERRCODE_STRING_DATA_LENGTH_MISMATCH
207 "string_data_right_truncation", ERRCODE_STRING_DATA_RIGHT_TRUNCATION
211 "substring_error", ERRCODE_SUBSTRING_ERROR
215 "trim_error", ERRCODE_TRIM_ERROR
219 "unterminated_c_string", ERRCODE_UNTERMINATED_C_STRING
223 "zero_length_character_string", ERRCODE_ZERO_LENGTH_CHARACTER_STRING
227 "floating_point_exception", ERRCODE_FLOATING_POINT_EXCEPTION
231 "invalid_text_representation", ERRCODE_INVALID_TEXT_REPRESENTATION
235 "invalid_binary_representation", ERRCODE_INVALID_BINARY_REPRESENTATION
239 "bad_copy_file_format", ERRCODE_BAD_COPY_FILE_FORMAT
243 "untranslatable_character", ERRCODE_UNTRANSLATABLE_CHARACTER
247 "integrity_constraint_violation", ERRCODE_INTEGRITY_CONSTRAINT_VIOLATION
251 "restrict_violation", ERRCODE_RESTRICT_VIOLATION
255 "not_null_violation", ERRCODE_NOT_NULL_VIOLATION
259 "foreign_key_violation", ERRCODE_FOREIGN_KEY_VIOLATION
263 "unique_violation", ERRCODE_UNIQUE_VIOLATION
267 "check_violation", ERRCODE_CHECK_VIOLATION
271 "invalid_cursor_state", ERRCODE_INVALID_CURSOR_STATE
275 "invalid_transaction_state", ERRCODE_INVALID_TRANSACTION_STATE
279 "active_sql_transaction", ERRCODE_ACTIVE_SQL_TRANSACTION
283 "branch_transaction_already_active", ERRCODE_BRANCH_TRANSACTION_ALREADY_ACTIVE
287 "held_cursor_requires_same_isolation_level", ERRCODE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL
291 "inappropriate_access_mode_for_branch_transaction", ERRCODE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION
295 "inappropriate_isolation_level_for_branch_transaction", ERRCODE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION
299 "no_active_sql_transaction_for_branch_transaction", ERRCODE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION
303 "read_only_sql_transaction", ERRCODE_READ_ONLY_SQL_TRANSACTION
307 "schema_and_data_statement_mixing_not_supported", ERRCODE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED
311 "no_active_sql_transaction", ERRCODE_NO_ACTIVE_SQL_TRANSACTION
315 "in_failed_sql_transaction", ERRCODE_IN_FAILED_SQL_TRANSACTION
319 "invalid_sql_statement_name", ERRCODE_INVALID_SQL_STATEMENT_NAME
323 "triggered_data_change_violation", ERRCODE_TRIGGERED_DATA_CHANGE_VIOLATION
327 "invalid_authorization_specification", ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION
331 "dependent_privilege_descriptors_still_exist", ERRCODE_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST
335 "dependent_objects_still_exist", ERRCODE_DEPENDENT_OBJECTS_STILL_EXIST
339 "invalid_transaction_termination", ERRCODE_INVALID_TRANSACTION_TERMINATION
343 "sql_routine_exception", ERRCODE_SQL_ROUTINE_EXCEPTION
347 "function_executed_no_return_statement", ERRCODE_S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT
351 "modifying_sql_data_not_permitted", ERRCODE_S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED
355 "prohibited_sql_statement_attempted", ERRCODE_S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED
359 "reading_sql_data_not_permitted", ERRCODE_S_R_E_READING_SQL_DATA_NOT_PERMITTED
363 "invalid_cursor_name", ERRCODE_INVALID_CURSOR_NAME
367 "external_routine_exception", ERRCODE_EXTERNAL_ROUTINE_EXCEPTION
371 "containing_sql_not_permitted", ERRCODE_E_R_E_CONTAINING_SQL_NOT_PERMITTED
375 "modifying_sql_data_not_permitted", ERRCODE_E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED
379 "prohibited_sql_statement_attempted", ERRCODE_E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED
383 "reading_sql_data_not_permitted", ERRCODE_E_R_E_READING_SQL_DATA_NOT_PERMITTED
387 "external_routine_invocation_exception", ERRCODE_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION
391 "invalid_sqlstate_returned", ERRCODE_E_R_I_E_INVALID_SQLSTATE_RETURNED
395 "null_value_not_allowed", ERRCODE_E_R_I_E_NULL_VALUE_NOT_ALLOWED
399 "trigger_protocol_violated", ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED
403 "srf_protocol_violated", ERRCODE_E_R_I_E_SRF_PROTOCOL_VIOLATED
407 "savepoint_exception", ERRCODE_SAVEPOINT_EXCEPTION
411 "invalid_savepoint_specification", ERRCODE_S_E_INVALID_SPECIFICATION
415 "invalid_catalog_name", ERRCODE_INVALID_CATALOG_NAME
419 "invalid_schema_name", ERRCODE_INVALID_SCHEMA_NAME
423 "transaction_rollback", ERRCODE_TRANSACTION_ROLLBACK
427 "transaction_integrity_constraint_violation", ERRCODE_T_R_INTEGRITY_CONSTRAINT_VIOLATION
431 "serialization_failure", ERRCODE_T_R_SERIALIZATION_FAILURE
435 "statement_completion_unknown", ERRCODE_T_R_STATEMENT_COMPLETION_UNKNOWN
439 "deadlock_detected", ERRCODE_T_R_DEADLOCK_DETECTED
443 "syntax_error_or_access_rule_violation", ERRCODE_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION
447 "syntax_error", ERRCODE_SYNTAX_ERROR
451 "insufficient_privilege", ERRCODE_INSUFFICIENT_PRIVILEGE
455 "cannot_coerce", ERRCODE_CANNOT_COERCE
459 "grouping_error", ERRCODE_GROUPING_ERROR
463 "invalid_foreign_key", ERRCODE_INVALID_FOREIGN_KEY
467 "invalid_name", ERRCODE_INVALID_NAME
471 "name_too_long", ERRCODE_NAME_TOO_LONG
475 "reserved_name", ERRCODE_RESERVED_NAME
479 "datatype_mismatch", ERRCODE_DATATYPE_MISMATCH
483 "indeterminate_datatype", ERRCODE_INDETERMINATE_DATATYPE
487 "wrong_object_type", ERRCODE_WRONG_OBJECT_TYPE
491 "undefined_column", ERRCODE_UNDEFINED_COLUMN
495 "undefined_cursor", ERRCODE_UNDEFINED_CURSOR
499 "undefined_database", ERRCODE_UNDEFINED_DATABASE
503 "undefined_function", ERRCODE_UNDEFINED_FUNCTION
507 "undefined_pstatement", ERRCODE_UNDEFINED_PSTATEMENT
511 "undefined_schema", ERRCODE_UNDEFINED_SCHEMA
515 "undefined_table", ERRCODE_UNDEFINED_TABLE
519 "undefined_parameter", ERRCODE_UNDEFINED_PARAMETER
523 "undefined_object", ERRCODE_UNDEFINED_OBJECT
527 "duplicate_column", ERRCODE_DUPLICATE_COLUMN
531 "duplicate_cursor", ERRCODE_DUPLICATE_CURSOR
535 "duplicate_database", ERRCODE_DUPLICATE_DATABASE
539 "duplicate_function", ERRCODE_DUPLICATE_FUNCTION
543 "duplicate_prepared_statement", ERRCODE_DUPLICATE_PSTATEMENT
547 "duplicate_schema", ERRCODE_DUPLICATE_SCHEMA
551 "duplicate_table", ERRCODE_DUPLICATE_TABLE
555 "duplicate_alias", ERRCODE_DUPLICATE_ALIAS
559 "duplicate_object", ERRCODE_DUPLICATE_OBJECT
563 "ambiguous_column", ERRCODE_AMBIGUOUS_COLUMN
567 "ambiguous_function", ERRCODE_AMBIGUOUS_FUNCTION
571 "ambiguous_parameter", ERRCODE_AMBIGUOUS_PARAMETER
575 "ambiguous_alias", ERRCODE_AMBIGUOUS_ALIAS
579 "invalid_column_reference", ERRCODE_INVALID_COLUMN_REFERENCE
583 "invalid_column_definition", ERRCODE_INVALID_COLUMN_DEFINITION
587 "invalid_cursor_definition", ERRCODE_INVALID_CURSOR_DEFINITION
591 "invalid_database_definition", ERRCODE_INVALID_DATABASE_DEFINITION
595 "invalid_function_definition", ERRCODE_INVALID_FUNCTION_DEFINITION
599 "invalid_prepared_statement_definition", ERRCODE_INVALID_PSTATEMENT_DEFINITION
603 "invalid_schema_definition", ERRCODE_INVALID_SCHEMA_DEFINITION
607 "invalid_table_definition", ERRCODE_INVALID_TABLE_DEFINITION
611 "invalid_object_definition", ERRCODE_INVALID_OBJECT_DEFINITION
615 "with_check_option_violation", ERRCODE_WITH_CHECK_OPTION_VIOLATION
619 "insufficient_resources", ERRCODE_INSUFFICIENT_RESOURCES
623 "disk_full", ERRCODE_DISK_FULL
627 "out_of_memory", ERRCODE_OUT_OF_MEMORY
631 "too_many_connections", ERRCODE_TOO_MANY_CONNECTIONS
635 "program_limit_exceeded", ERRCODE_PROGRAM_LIMIT_EXCEEDED
639 "statement_too_complex", ERRCODE_STATEMENT_TOO_COMPLEX
643 "too_many_columns", ERRCODE_TOO_MANY_COLUMNS
647 "too_many_arguments", ERRCODE_TOO_MANY_ARGUMENTS
651 "object_not_in_prerequisite_state", ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE
655 "object_in_use", ERRCODE_OBJECT_IN_USE
659 "cant_change_runtime_param", ERRCODE_CANT_CHANGE_RUNTIME_PARAM
663 "lock_not_available", ERRCODE_LOCK_NOT_AVAILABLE
667 "operator_intervention", ERRCODE_OPERATOR_INTERVENTION
671 "query_canceled", ERRCODE_QUERY_CANCELED
675 "admin_shutdown", ERRCODE_ADMIN_SHUTDOWN
679 "crash_shutdown", ERRCODE_CRASH_SHUTDOWN
683 "cannot_connect_now", ERRCODE_CANNOT_CONNECT_NOW
687 "io_error", ERRCODE_IO_ERROR
691 "undefined_file", ERRCODE_UNDEFINED_FILE
695 "duplicate_file", ERRCODE_DUPLICATE_FILE
699 "config_file_error", ERRCODE_CONFIG_FILE_ERROR
703 "lock_file_exists", ERRCODE_LOCK_FILE_EXISTS
707 "plpgsql_error", ERRCODE_PLPGSQL_ERROR
711 "raise_exception", ERRCODE_RAISE_EXCEPTION
715 "internal_error", ERRCODE_INTERNAL_ERROR
719 "data_corrupted", ERRCODE_DATA_CORRUPTED
723 "index_corrupted", ERRCODE_INDEX_CORRUPTED