-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpgErrorCodes.ts
260 lines (260 loc) · 10.3 KB
/
pgErrorCodes.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
export const errorCodes: { [code: string]: string } = {
"20000": "case_not_found",
"21000": "cardinality_violation",
"22000": "data_exception",
"22001": "string_data_right_truncation",
"22002": "null_value_no_indicator_parameter",
"22003": "numeric_value_out_of_range",
"22004": "null_value_not_allowed",
"22005": "error_in_assignment",
"22007": "invalid_datetime_format",
"22008": "datetime_field_overflow",
"22009": "invalid_time_zone_displacement_value",
"22010": "invalid_indicator_parameter_value",
"22011": "substring_error",
"22012": "division_by_zero",
"22013": "invalid_preceding_or_following_size",
"22014": "invalid_argument_for_ntile_function",
"22015": "interval_field_overflow",
"22016": "invalid_argument_for_nth_value_function",
"22018": "invalid_character_value_for_cast",
"22019": "invalid_escape_character",
"22021": "character_not_in_repertoire",
"22022": "indicator_overflow",
"22023": "invalid_parameter_value",
"22024": "unterminated_c_string",
"22025": "invalid_escape_sequence",
"22026": "string_data_length_mismatch",
"22027": "trim_error",
"22030": "duplicate_json_object_key_value",
"22031": "invalid_argument_for_sql_json_datetime_function",
"22032": "invalid_json_text",
"22033": "invalid_sql_json_subscript",
"22034": "more_than_one_sql_json_item",
"22035": "no_sql_json_item",
"22036": "non_numeric_sql_json_item",
"22037": "non_unique_keys_in_a_json_object",
"22038": "singleton_sql_json_item_required",
"22039": "sql_json_array_not_found",
"23000": "integrity_constraint_violation",
"23001": "restrict_violation",
"23502": "not_null_violation",
"23503": "foreign_key_violation",
"23505": "unique_violation",
"23514": "check_violation",
"24000": "invalid_cursor_state",
"25000": "invalid_transaction_state",
"25001": "active_sql_transaction",
"25002": "branch_transaction_already_active",
"25003": "inappropriate_access_mode_for_branch_transaction",
"25004": "inappropriate_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",
"25008": "held_cursor_requires_same_isolation_level",
"26000": "invalid_sql_statement_name",
"27000": "triggered_data_change_violation",
"28000": "invalid_authorization_specification",
"34000": "invalid_cursor_name",
"38000": "external_routine_exception",
"38001": "containing_sql_not_permitted",
"38002": "modifying_sql_data_not_permitted",
"38003": "prohibited_sql_statement_attempted",
"38004": "reading_sql_data_not_permitted",
"39000": "external_routine_invocation_exception",
"39001": "invalid_sqlstate_returned",
"39004": "null_value_not_allowed",
"40000": "transaction_rollback",
"40001": "serialization_failure",
"40002": "transaction_integrity_constraint_violation",
"40003": "statement_completion_unknown",
"42000": "syntax_error_or_access_rule_violation",
"42501": "insufficient_privilege",
"42601": "syntax_error",
"42602": "invalid_name",
"42611": "invalid_column_definition",
"42622": "name_too_long",
"42701": "duplicate_column",
"42702": "ambiguous_column",
"42703": "undefined_column",
"42704": "undefined_object",
"42710": "duplicate_object",
"42712": "duplicate_alias",
"42723": "duplicate_function",
"42725": "ambiguous_function",
"42803": "grouping_error",
"42804": "datatype_mismatch",
"42809": "wrong_object_type",
"42830": "invalid_foreign_key",
"42846": "cannot_coerce",
"42883": "undefined_function",
"42939": "reserved_name",
"44000": "with_check_option_violation",
"53000": "insufficient_resources",
"53100": "disk_full",
"53200": "out_of_memory",
"53300": "too_many_connections",
"53400": "configuration_limit_exceeded",
"54000": "program_limit_exceeded",
"54001": "statement_too_complex",
"54011": "too_many_columns",
"54023": "too_many_arguments",
"55000": "object_not_in_prerequisite_state",
"55006": "object_in_use",
"57000": "operator_intervention",
"57014": "query_canceled",
"58000": "system_error",
"58030": "io_error",
"72000": "snapshot_too_old",
"00000": "successful_completion",
"01000": "warning",
"0100C": "dynamic_result_sets_returned",
"01008": "implicit_zero_bit_padding",
"01003": "null_value_eliminated_in_set_function",
"01007": "privilege_not_granted",
"01006": "privilege_not_revoked",
"01004": "string_data_right_truncation",
"01P01": "deprecated_feature",
"02000": "no_data",
"02001": "no_additional_dynamic_result_sets_returned",
"03000": "sql_statement_not_yet_complete",
"08000": "connection_exception",
"08003": "connection_does_not_exist",
"08006": "connection_failure",
"08001": "sqlclient_unable_to_establish_sqlconnection",
"08004": "sqlserver_rejected_establishment_of_sqlconnection",
"08007": "transaction_resolution_unknown",
"08P01": "protocol_violation",
"09000": "triggered_action_exception",
"0A000": "feature_not_supported",
"0B000": "invalid_transaction_initiation",
"0F000": "locator_exception",
"0F001": "invalid_locator_specification",
"0L000": "invalid_grantor",
"0LP01": "invalid_grant_operation",
"0P000": "invalid_role_specification",
"0Z000": "diagnostics_exception",
"0Z002": "stacked_diagnostics_accessed_without_active_handler",
"2202E": "array_subscript_error",
"2200B": "escape_character_conflict",
"2201E": "invalid_argument_for_logarithm",
"2201F": "invalid_argument_for_power_function",
"2201G": "invalid_argument_for_width_bucket_function",
"2200D": "invalid_escape_octet",
"22P06": "nonstandard_use_of_escape_character",
"2201B": "invalid_regular_expression",
"2201W": "invalid_row_count_in_limit_clause",
"2201X": "invalid_row_count_in_result_offset_clause",
"2202H": "invalid_tablesample_argument",
"2202G": "invalid_tablesample_repeat",
"2200C": "invalid_use_of_escape_character",
"2200G": "most_specific_type_mismatch",
"2200H": "sequence_generator_limit_exceeded",
"2200F": "zero_length_character_string",
"22P01": "floating_point_exception",
"22P02": "invalid_text_representation",
"22P03": "invalid_binary_representation",
"22P04": "bad_copy_file_format",
"22P05": "untranslatable_character",
"2200L": "not_an_xml_document",
"2200M": "invalid_xml_document",
"2200N": "invalid_xml_content",
"2200S": "invalid_xml_comment",
"2200T": "invalid_xml_processing_instruction",
"2203A": "sql_json_member_not_found",
"2203B": "sql_json_number_not_found",
"2203C": "sql_json_object_not_found",
"2203D": "too_many_json_array_elements",
"2203E": "too_many_json_object_members",
"2203F": "sql_json_scalar_required",
"23P01": "exclusion_violation",
"25P01": "no_active_sql_transaction",
"25P02": "in_failed_sql_transaction",
"25P03": "idle_in_transaction_session_timeout",
"28P01": "invalid_password",
"2B000": "dependent_privilege_descriptors_still_exist",
"2BP01": "dependent_objects_still_exist",
"2D000": "invalid_transaction_termination",
"2F000": "sql_routine_exception",
"2F005": "function_executed_no_return_statement",
"2F002": "modifying_sql_data_not_permitted",
"2F003": "prohibited_sql_statement_attempted",
"2F004": "reading_sql_data_not_permitted",
"39P01": "trigger_protocol_violated",
"39P02": "srf_protocol_violated",
"39P03": "event_trigger_protocol_violated",
"3B000": "savepoint_exception",
"3B001": "invalid_savepoint_specification",
"3D000": "invalid_catalog_name",
"3F000": "invalid_schema_name",
"40P01": "deadlock_detected",
"42P20": "windowing_error",
"42P19": "invalid_recursion",
"42P18": "indeterminate_datatype",
"42P21": "collation_mismatch",
"42P22": "indeterminate_collation",
"428C9": "generated_always",
"42P01": "undefined_table",
"42P02": "undefined_parameter",
"42P03": "duplicate_cursor",
"42P04": "duplicate_database",
"42P05": "duplicate_prepared_statement",
"42P06": "duplicate_schema",
"42P07": "duplicate_table",
"42P08": "ambiguous_parameter",
"42P09": "ambiguous_alias",
"42P10": "invalid_column_reference",
"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",
"55P02": "cant_change_runtime_param",
"55P03": "lock_not_available",
"55P04": "unsafe_new_enum_value_usage",
"57P01": "admin_shutdown",
"57P02": "crash_shutdown",
"57P03": "cannot_connect_now",
"57P04": "database_dropped",
"58P01": "undefined_file",
"58P02": "duplicate_file",
F0000: "config_file_error",
F0001: "lock_file_exists",
HV000: "fdw_error",
HV005: "fdw_column_name_not_found",
HV002: "fdw_dynamic_parameter_value_needed",
HV010: "fdw_function_sequence_error",
HV021: "fdw_inconsistent_descriptor_information",
HV024: "fdw_invalid_attribute_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_establish_connection",
P0000: "plpgsql_error",
P0001: "raise_exception",
P0002: "no_data_found",
P0003: "too_many_rows",
P0004: "assert_failure",
XX000: "internal_error",
XX001: "data_corrupted",
XX002: "index_corrupted",
};