이 문서는 지원되지 않는 버전의 토토 핫을위한 것입니다.
당신은에 대해 같은 페이지를 볼 수 있습니다PostgreSQL : 문서 : 17 : 부록 A. PostgreSQL 토토 꽁 머니 코드버전 또는 위에 나열된 다른 지원 버전 중 하나입니다.

부록 A.토토 핫오류 토토 핫

토토 핫서버가 할당되었습니다"sqlstate"토토 핫.토토 핫릴리스 및토토 핫

표준에 따르면, 처음 두 문자

표 A-1정의 된 모든 오류 토토 핫 나열토토 핫9.2.24. (일부는 실제로 아닙니다"표준"마지막이있는 오류 토토 핫000. 이 토토 핫가 사용됩니다

열에 표시된 기호"조건pl/pgsql. 조건 이름을 작성할 수 있습니다pl/pgsql경고를 인식하지 못합니다

표 A-1.토토 핫오류 토토 핫

오류 토토 핫 조건 이름
클래스 00 -
00000 success_completion
클래스 01 -
01000 경고
0100C dynamic_result_sets_returned
01008 implicit_zero_bit_padding
01003 null_value_eliminated_in_set_function
01007 PRICILEGE_NOT_GRANTED
01006 PRICILEGE_NOT_REVOKED
01004 String_data_right_truncation
01P01 wamberated_feature
클래스 02 -
02000 no_data
02001 no_additional_dynamic_result_sets_returned
클래스 03 -
03000 sql_statement_not_yet_complete
클래스 08 -
08000 Connection_Exception
08003 Connection_does_NOT_EXIST
08006 Connection_Failure
08001 SQLCLIENT_UNABLE_TO_STABLISH_SQLCONNECTION
08004 sqlserver_rejected_establishment_of_sqlconnection
08007 Transaction_Resolution_unkNown
08p01 Protocol_violation
클래스 09 -
09000 Triggered_Action_Exception
클래스 0A -
0A000 feaction_not_supported
클래스 0B -
0B000 invalid_transaction_initiation
클래스 0F -
0f000 locator_exception
0F001 invalid_locator_specification
클래스 0L -
0L000 invalid_grantor
0LP01 invalid_grant_operation
클래스 0p -
0p000 invalid_role_specification
클래스 0Z -
0z000 Diagnostics_Exception
0Z002 stacked_diagnostics_accessed_without_active_handler
클래스 20 -
20000 case_not_found
클래스 21 -
21000 Cardinality_violation
클래스 22 -
22000 data_exception
2202E array_subscript_error
22021 character_not_in_repertoire
22008 dateTime_field_overflow
22012 division_by_zero
22005 ERROR_IN_ASSIGNMENT
2200B Escape_Character_Conflict
22022 indicator_overflow
22015 interval_field_overflow
2201E invalid_argument_for_logarithm
22014 invalid_argument_for_ntile_function
22016 invalid_argument_for_nth_value_function
2201f invalid_argument_for_power_function
2201G invalid_argument_for_width_bucket_function
22018 invalid_character_value_for_cast
22007 invalid_datetime_format
22019 invalid_escape_character
2200d invalid_escape_octet
22025 invalid_escape_sequence
22P06 nonstandard_use_of_escape_character
22010 invalid_indicator_parameter_value
22023 invalid_parameter_value
2201B invalid_regular_expression
2201W invalid_row_count_in_limit_clause
2201X invalid_row_count_in_result_offset_clause
22009 invalid_time_zone_displacement_value
2200c invalid_use_of_escape_character
2200g most_specific_type_mistatch
22004 null_value_not_allowed
22002 null_value_no_indicator_parameter
22003 numeric_value_out_of_range
22026 String_data_length_mistatch
22001 String_data_right_truncation
22011 substring_error
22027 trim_error
22024 Unterminated_c_string
2200f Zero_length_character_string
22P01 floating_point_exception
22P02 invalid_text_representation
22p03 invalid_binary_representation
22P04 bad_copy_file_format
22P05 변환 가능한 _character
2200L not_an_xml_document
2200m invalid_xml_document
2200N invalid_xml_content
2200S invalid_xml_comment
2200t invalid_xml_processing_instruction
클래스 23 -
23000 Integrity_Constraint_Violation
23001 제한 _violation
23502 not_null_violation
23503 forex_key_violation
23505 고유 _violation
23514 check_violation
23p01 제외 _violation
클래스 24 -
24000 invalid_cursor_state
클래스 25 -
25000 invalid_transaction_state
25001 active_sql_transaction
25002 branch_transaction_already_active
25008 held_cursor_requires_same_isolation_level
25003 inupript_access_mode_for_branch_transaction
25004 inupript_isolation_level_for_branch_transaction
25005 no_active_sql_transaction_for_branch_transaction
25006 read_only_sql_transaction
25007 schema_and_data_statement_mixing_not_supported
25p01 no_active_sql_transaction
25p02 in_failed_sql_transaction
클래스 26 -
26000 invalid_sql_statement_name
클래스 27 -
27000 triggered_data_change_violation
클래스 28 -
28000 invalid_authorization_specification
28p01 invalid_password
클래스 2B -
2B000 fexend_privilege_descriptors_still_exist
2BP01 fexenent_objects_still_exist
클래스 2D -
2d000 invalid_transaction_termination
클래스 2F -
2F000 sql_routine_exception
2F005 function_executed_no_return_statement
2F002 modifying_sql_data_not_permitted
2F003 prohibed_sql_statement_attempted
2F004 reading_sql_data_not_permitted
클래스 34 -
34000 invalid_cursor_name
클래스 38 -
38000 external_routine_exception
38001 containing_sql_not_permitted
38002 modifying_sql_data_not_permitted
38003 prohibed_sql_statement_attempted
38004 reading_sql_data_not_permitted
클래스 39 -
39000 external_routine_invocation_exception
39001 invalid_sqlstate_returned
39004 null_value_not_allowed
39p01 trigger_protocol_violated
39p02 SRF_PROTOCOL_VIOLATED
클래스 3B -
3B000 SavePoint_Exception
3B001 invalid_savepoint_specification
클래스 3D -
3D000 invalid_catalog_name
클래스 3F -
3F000 invalid_schema_name
클래스 40 -
40000 Transaction_Rollback
40002 transaction_integrity_constraint_violation
40001 Serialization_Failure
40003 state_completion_unknown
40p01 Deadlock_detected
클래스 42 -
42000 SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION
42601 syntax_error
42501 불충분 한 _privilege
42846 CALE_COERCE
42803 Grouping_error
42p20 Windowing_error
42p19 invalid_recursion
42830 invalid_foreign_key
42602 invalid_name
42622 name_too_long
42939 Reserved_name
42804 DataType_mistatch
42p18 불확실한 _datatype
42p21 collation_mistatch
42P22 Insterminate_Collation
42809 잘못 _object_type
42703 undefined_column
42883 undefined_function
42p01 undefined_table
42p02 undefined_parameter
42704 undefined_object
42701 duplical_column
42p03 duplical_cursor
42p04 duplice_database
42723 duplical_function
42p05 duplical_prepared_statement
42p06 duplice_schema
42p07 duplical_table
42712 duplical_alias
42710 duplical_object
42702 Ambiguous_Column
42725 Ambiguous_Function
42p08 Ambiguous_Parameter
42p09 Ambiguous_alias
42p10 invalid_column_reference
42611 invalid_column_definition
42p11 invalid_cursor_definition
42p12 invalid_database_definition
42p13 invalid_function_definition
42p14 invalid_prepared_statement_definition
42p15 invalid_schema_definition
42p16 invalid_table_definition
42p17 invalid_object_definition
클래스 44 -
44000 with_check_option_violation
클래스 53 -
53000 Insufficile _resources
53100 disk_full
53200 out_of_memory
53300 TOO_MANY_CONNECTION
53400 configuration_limit_execeeded
클래스 54 -
54000 program_limit_execeeded
54001 station_too_complex
54011 TOO_MANY_COLUMNS
54023 TOO_MANY_ARGUMents
클래스 55 -
55000 object_not_in_prerequisite_state
55006 Object_in_use
55p02 cant_change_runtime_param
55p03 lock_not_available
클래스 57 -
57000 Operator_Intervention
57014 query_canceled
57p01 admin_shutdown
57p02 Crash_Shutdown
57p03 cann_connect_now
57p04 database_dropped
클래스 58 -토토 핫자체)
58000 System_Error
58030 io_error
58p01 undefined_file
58p02 duplical_file
클래스 F0 -
F0000 config_file_error
F0001 lock_file_exists
클래스 HV -
HV000 fdw_error
HV005 FDW_COLUMN_NAME_NOT_FOUND
HV002 FDW_DYNAMIC_PARAMETER_VALUE_NEEDED
HV010 FDW_FUNCTION_SEMATENT_ERROR
HV021 fdw_inconsistent_descriptor_information
HV024 FDW_INVALID_ATTRIBER_VALUE
HV007 FDW_INVALID_COLUMN_NAME
HV008 FDW_INVALID_COLUMN_NUMBER
HV004 FDW_INVALID_DATA_TYPE
HV006 FDW_INVALID_DATA_TYPE_DESCRIPTORS
HV091 fdw_invalid_descriptor_field_identifier
HV00B FDW_INVALID_HANDLE
HV00C FDW_INVALID_OPTION_INDEX
HV00D FDW_INVALID_OPTION_NAME
HV090 fdw_invalid_string_length_or_buffer_length
HV00A fdw_invalid_string_format
HV009 fdw_invalid_use_of_null_pointer
HV014 FDW_TOO_MANY_HANDLES
HV001 fdw_out_of_memory
HV00P FDW_NO_SCHEMAS
HV00J fdw_option_name_not_found
HV00K FDW_REPLY_HANDLE
HV00Q FDW_SCHEMA_NOT_FOUND
HV00R fdw_table_not_found
HV00L fdw_unable_to_create_execution
HV00M fdw_unable_to_create_reply
HV00N FDW_UNABLE_TO_STABLISH_CONNECTION
클래스 P0 -
P0000 plpgsql_error
P0001 rase_exception
P0002 no_data_found
P0003 TOO_MANY_ROWS
클래스 XX -
xx000 Internal_error
xx001 data_corrupted
XX002 index_corrupted