]> granicus.if.org Git - postgresql/blob - src/pl/plpgsql/src/plerrcodes.h
For some reason access/tupmacs.h has been #including utils/memutils.h,
[postgresql] / src / pl / plpgsql / src / plerrcodes.h
1 /*-------------------------------------------------------------------------
2  *
3  * plerrcodes.h
4  *        PL/pgSQL error codes (mapping of exception labels to SQLSTATEs)
5  *
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 ...
9  *
10  * Copyright (c) 2003-2005, PostgreSQL Global Development Group
11  *
12  * $PostgreSQL: pgsql/src/pl/plpgsql/src/plerrcodes.h,v 1.6 2005/01/01 20:44:32 tgl Exp $
13  *
14  *-------------------------------------------------------------------------
15  */
16
17 /* Success and warnings can't be caught, so omit them from table */
18 {
19         "sql_statement_not_yet_complete", ERRCODE_SQL_STATEMENT_NOT_YET_COMPLETE
20 },
21
22 {
23         "connection_exception", ERRCODE_CONNECTION_EXCEPTION
24 },
25
26 {
27         "connection_does_not_exist", ERRCODE_CONNECTION_DOES_NOT_EXIST
28 },
29
30 {
31         "connection_failure", ERRCODE_CONNECTION_FAILURE
32 },
33
34 {
35         "sqlclient_unable_to_establish_sqlconnection", ERRCODE_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION
36 },
37
38 {
39         "sqlserver_rejected_establishment_of_sqlconnection", ERRCODE_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION
40 },
41
42 {
43         "transaction_resolution_unknown", ERRCODE_TRANSACTION_RESOLUTION_UNKNOWN
44 },
45
46 {
47         "protocol_violation", ERRCODE_PROTOCOL_VIOLATION
48 },
49
50 {
51         "triggered_action_exception", ERRCODE_TRIGGERED_ACTION_EXCEPTION
52 },
53
54 {
55         "feature_not_supported", ERRCODE_FEATURE_NOT_SUPPORTED
56 },
57
58 {
59         "invalid_transaction_initiation", ERRCODE_INVALID_TRANSACTION_INITIATION
60 },
61
62 {
63         "locator_exception", ERRCODE_LOCATOR_EXCEPTION
64 },
65
66 {
67         "invalid_locator_specification", ERRCODE_L_E_INVALID_SPECIFICATION
68 },
69
70 {
71         "invalid_grantor", ERRCODE_INVALID_GRANTOR
72 },
73
74 {
75         "invalid_grant_operation", ERRCODE_INVALID_GRANT_OPERATION
76 },
77
78 {
79         "invalid_role_specification", ERRCODE_INVALID_ROLE_SPECIFICATION
80 },
81
82 {
83         "cardinality_violation", ERRCODE_CARDINALITY_VIOLATION
84 },
85
86 {
87         "data_exception", ERRCODE_DATA_EXCEPTION
88 },
89
90 {
91         "array_element_error", ERRCODE_ARRAY_ELEMENT_ERROR
92 },
93
94 {
95         "array_subscript_error", ERRCODE_ARRAY_SUBSCRIPT_ERROR
96 },
97
98 {
99         "character_not_in_repertoire", ERRCODE_CHARACTER_NOT_IN_REPERTOIRE
100 },
101
102 {
103         "datetime_field_overflow", ERRCODE_DATETIME_FIELD_OVERFLOW
104 },
105
106 {
107         "datetime_value_out_of_range", ERRCODE_DATETIME_VALUE_OUT_OF_RANGE
108 },
109
110 {
111         "division_by_zero", ERRCODE_DIVISION_BY_ZERO
112 },
113
114 {
115         "error_in_assignment", ERRCODE_ERROR_IN_ASSIGNMENT
116 },
117
118 {
119         "escape_character_conflict", ERRCODE_ESCAPE_CHARACTER_CONFLICT
120 },
121
122 {
123         "indicator_overflow", ERRCODE_INDICATOR_OVERFLOW
124 },
125
126 {
127         "interval_field_overflow", ERRCODE_INTERVAL_FIELD_OVERFLOW
128 },
129
130 {
131         "invalid_argument_for_logarithm", ERRCODE_INVALID_ARGUMENT_FOR_LOG
132 },
133
134 {
135         "invalid_argument_for_power_function", ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION
136 },
137
138 {
139         "invalid_argument_for_width_bucket_function", ERRCODE_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION
140 },
141
142 {
143         "invalid_character_value_for_cast", ERRCODE_INVALID_CHARACTER_VALUE_FOR_CAST
144 },
145
146 {
147         "invalid_datetime_format", ERRCODE_INVALID_DATETIME_FORMAT
148 },
149
150 {
151         "invalid_escape_character", ERRCODE_INVALID_ESCAPE_CHARACTER
152 },
153
154 {
155         "invalid_escape_octet", ERRCODE_INVALID_ESCAPE_OCTET
156 },
157
158 {
159         "invalid_escape_sequence", ERRCODE_INVALID_ESCAPE_SEQUENCE
160 },
161
162 {
163         "invalid_indicator_parameter_value", ERRCODE_INVALID_INDICATOR_PARAMETER_VALUE
164 },
165
166 {
167         "invalid_limit_value", ERRCODE_INVALID_LIMIT_VALUE
168 },
169
170 {
171         "invalid_parameter_value", ERRCODE_INVALID_PARAMETER_VALUE
172 },
173
174 {
175         "invalid_regular_expression", ERRCODE_INVALID_REGULAR_EXPRESSION
176 },
177
178 {
179         "invalid_time_zone_displacement_value", ERRCODE_INVALID_TIME_ZONE_DISPLACEMENT_VALUE
180 },
181
182 {
183         "invalid_use_of_escape_character", ERRCODE_INVALID_USE_OF_ESCAPE_CHARACTER
184 },
185
186 {
187         "most_specific_type_mismatch", ERRCODE_MOST_SPECIFIC_TYPE_MISMATCH
188 },
189
190 {
191         "null_value_not_allowed", ERRCODE_NULL_VALUE_NOT_ALLOWED
192 },
193
194 {
195         "null_value_no_indicator_parameter", ERRCODE_NULL_VALUE_NO_INDICATOR_PARAMETER
196 },
197
198 {
199         "numeric_value_out_of_range", ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE
200 },
201
202 {
203         "string_data_length_mismatch", ERRCODE_STRING_DATA_LENGTH_MISMATCH
204 },
205
206 {
207         "string_data_right_truncation", ERRCODE_STRING_DATA_RIGHT_TRUNCATION
208 },
209
210 {
211         "substring_error", ERRCODE_SUBSTRING_ERROR
212 },
213
214 {
215         "trim_error", ERRCODE_TRIM_ERROR
216 },
217
218 {
219         "unterminated_c_string", ERRCODE_UNTERMINATED_C_STRING
220 },
221
222 {
223         "zero_length_character_string", ERRCODE_ZERO_LENGTH_CHARACTER_STRING
224 },
225
226 {
227         "floating_point_exception", ERRCODE_FLOATING_POINT_EXCEPTION
228 },
229
230 {
231         "invalid_text_representation", ERRCODE_INVALID_TEXT_REPRESENTATION
232 },
233
234 {
235         "invalid_binary_representation", ERRCODE_INVALID_BINARY_REPRESENTATION
236 },
237
238 {
239         "bad_copy_file_format", ERRCODE_BAD_COPY_FILE_FORMAT
240 },
241
242 {
243         "untranslatable_character", ERRCODE_UNTRANSLATABLE_CHARACTER
244 },
245
246 {
247         "integrity_constraint_violation", ERRCODE_INTEGRITY_CONSTRAINT_VIOLATION
248 },
249
250 {
251         "restrict_violation", ERRCODE_RESTRICT_VIOLATION
252 },
253
254 {
255         "not_null_violation", ERRCODE_NOT_NULL_VIOLATION
256 },
257
258 {
259         "foreign_key_violation", ERRCODE_FOREIGN_KEY_VIOLATION
260 },
261
262 {
263         "unique_violation", ERRCODE_UNIQUE_VIOLATION
264 },
265
266 {
267         "check_violation", ERRCODE_CHECK_VIOLATION
268 },
269
270 {
271         "invalid_cursor_state", ERRCODE_INVALID_CURSOR_STATE
272 },
273
274 {
275         "invalid_transaction_state", ERRCODE_INVALID_TRANSACTION_STATE
276 },
277
278 {
279         "active_sql_transaction", ERRCODE_ACTIVE_SQL_TRANSACTION
280 },
281
282 {
283         "branch_transaction_already_active", ERRCODE_BRANCH_TRANSACTION_ALREADY_ACTIVE
284 },
285
286 {
287         "held_cursor_requires_same_isolation_level", ERRCODE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL
288 },
289
290 {
291         "inappropriate_access_mode_for_branch_transaction", ERRCODE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION
292 },
293
294 {
295         "inappropriate_isolation_level_for_branch_transaction", ERRCODE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION
296 },
297
298 {
299         "no_active_sql_transaction_for_branch_transaction", ERRCODE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION
300 },
301
302 {
303         "read_only_sql_transaction", ERRCODE_READ_ONLY_SQL_TRANSACTION
304 },
305
306 {
307         "schema_and_data_statement_mixing_not_supported", ERRCODE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED
308 },
309
310 {
311         "no_active_sql_transaction", ERRCODE_NO_ACTIVE_SQL_TRANSACTION
312 },
313
314 {
315         "in_failed_sql_transaction", ERRCODE_IN_FAILED_SQL_TRANSACTION
316 },
317
318 {
319         "invalid_sql_statement_name", ERRCODE_INVALID_SQL_STATEMENT_NAME
320 },
321
322 {
323         "triggered_data_change_violation", ERRCODE_TRIGGERED_DATA_CHANGE_VIOLATION
324 },
325
326 {
327         "invalid_authorization_specification", ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION
328 },
329
330 {
331         "dependent_privilege_descriptors_still_exist", ERRCODE_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST
332 },
333
334 {
335         "dependent_objects_still_exist", ERRCODE_DEPENDENT_OBJECTS_STILL_EXIST
336 },
337
338 {
339         "invalid_transaction_termination", ERRCODE_INVALID_TRANSACTION_TERMINATION
340 },
341
342 {
343         "sql_routine_exception", ERRCODE_SQL_ROUTINE_EXCEPTION
344 },
345
346 {
347         "function_executed_no_return_statement", ERRCODE_S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT
348 },
349
350 {
351         "modifying_sql_data_not_permitted", ERRCODE_S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED
352 },
353
354 {
355         "prohibited_sql_statement_attempted", ERRCODE_S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED
356 },
357
358 {
359         "reading_sql_data_not_permitted", ERRCODE_S_R_E_READING_SQL_DATA_NOT_PERMITTED
360 },
361
362 {
363         "invalid_cursor_name", ERRCODE_INVALID_CURSOR_NAME
364 },
365
366 {
367         "external_routine_exception", ERRCODE_EXTERNAL_ROUTINE_EXCEPTION
368 },
369
370 {
371         "containing_sql_not_permitted", ERRCODE_E_R_E_CONTAINING_SQL_NOT_PERMITTED
372 },
373
374 {
375         "modifying_sql_data_not_permitted", ERRCODE_E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED
376 },
377
378 {
379         "prohibited_sql_statement_attempted", ERRCODE_E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED
380 },
381
382 {
383         "reading_sql_data_not_permitted", ERRCODE_E_R_E_READING_SQL_DATA_NOT_PERMITTED
384 },
385
386 {
387         "external_routine_invocation_exception", ERRCODE_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION
388 },
389
390 {
391         "invalid_sqlstate_returned", ERRCODE_E_R_I_E_INVALID_SQLSTATE_RETURNED
392 },
393
394 {
395         "null_value_not_allowed", ERRCODE_E_R_I_E_NULL_VALUE_NOT_ALLOWED
396 },
397
398 {
399         "trigger_protocol_violated", ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED
400 },
401
402 {
403         "srf_protocol_violated", ERRCODE_E_R_I_E_SRF_PROTOCOL_VIOLATED
404 },
405
406 {
407         "savepoint_exception", ERRCODE_SAVEPOINT_EXCEPTION
408 },
409
410 {
411         "invalid_savepoint_specification", ERRCODE_S_E_INVALID_SPECIFICATION
412 },
413
414 {
415         "invalid_catalog_name", ERRCODE_INVALID_CATALOG_NAME
416 },
417
418 {
419         "invalid_schema_name", ERRCODE_INVALID_SCHEMA_NAME
420 },
421
422 {
423         "transaction_rollback", ERRCODE_TRANSACTION_ROLLBACK
424 },
425
426 {
427         "transaction_integrity_constraint_violation", ERRCODE_T_R_INTEGRITY_CONSTRAINT_VIOLATION
428 },
429
430 {
431         "serialization_failure", ERRCODE_T_R_SERIALIZATION_FAILURE
432 },
433
434 {
435         "statement_completion_unknown", ERRCODE_T_R_STATEMENT_COMPLETION_UNKNOWN
436 },
437
438 {
439         "deadlock_detected", ERRCODE_T_R_DEADLOCK_DETECTED
440 },
441
442 {
443         "syntax_error_or_access_rule_violation", ERRCODE_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION
444 },
445
446 {
447         "syntax_error", ERRCODE_SYNTAX_ERROR
448 },
449
450 {
451         "insufficient_privilege", ERRCODE_INSUFFICIENT_PRIVILEGE
452 },
453
454 {
455         "cannot_coerce", ERRCODE_CANNOT_COERCE
456 },
457
458 {
459         "grouping_error", ERRCODE_GROUPING_ERROR
460 },
461
462 {
463         "invalid_foreign_key", ERRCODE_INVALID_FOREIGN_KEY
464 },
465
466 {
467         "invalid_name", ERRCODE_INVALID_NAME
468 },
469
470 {
471         "name_too_long", ERRCODE_NAME_TOO_LONG
472 },
473
474 {
475         "reserved_name", ERRCODE_RESERVED_NAME
476 },
477
478 {
479         "datatype_mismatch", ERRCODE_DATATYPE_MISMATCH
480 },
481
482 {
483         "indeterminate_datatype", ERRCODE_INDETERMINATE_DATATYPE
484 },
485
486 {
487         "wrong_object_type", ERRCODE_WRONG_OBJECT_TYPE
488 },
489
490 {
491         "undefined_column", ERRCODE_UNDEFINED_COLUMN
492 },
493
494 {
495         "undefined_cursor", ERRCODE_UNDEFINED_CURSOR
496 },
497
498 {
499         "undefined_database", ERRCODE_UNDEFINED_DATABASE
500 },
501
502 {
503         "undefined_function", ERRCODE_UNDEFINED_FUNCTION
504 },
505
506 {
507         "undefined_pstatement", ERRCODE_UNDEFINED_PSTATEMENT
508 },
509
510 {
511         "undefined_schema", ERRCODE_UNDEFINED_SCHEMA
512 },
513
514 {
515         "undefined_table", ERRCODE_UNDEFINED_TABLE
516 },
517
518 {
519         "undefined_parameter", ERRCODE_UNDEFINED_PARAMETER
520 },
521
522 {
523         "undefined_object", ERRCODE_UNDEFINED_OBJECT
524 },
525
526 {
527         "duplicate_column", ERRCODE_DUPLICATE_COLUMN
528 },
529
530 {
531         "duplicate_cursor", ERRCODE_DUPLICATE_CURSOR
532 },
533
534 {
535         "duplicate_database", ERRCODE_DUPLICATE_DATABASE
536 },
537
538 {
539         "duplicate_function", ERRCODE_DUPLICATE_FUNCTION
540 },
541
542 {
543         "duplicate_prepared_statement", ERRCODE_DUPLICATE_PSTATEMENT
544 },
545
546 {
547         "duplicate_schema", ERRCODE_DUPLICATE_SCHEMA
548 },
549
550 {
551         "duplicate_table", ERRCODE_DUPLICATE_TABLE
552 },
553
554 {
555         "duplicate_alias", ERRCODE_DUPLICATE_ALIAS
556 },
557
558 {
559         "duplicate_object", ERRCODE_DUPLICATE_OBJECT
560 },
561
562 {
563         "ambiguous_column", ERRCODE_AMBIGUOUS_COLUMN
564 },
565
566 {
567         "ambiguous_function", ERRCODE_AMBIGUOUS_FUNCTION
568 },
569
570 {
571         "ambiguous_parameter", ERRCODE_AMBIGUOUS_PARAMETER
572 },
573
574 {
575         "ambiguous_alias", ERRCODE_AMBIGUOUS_ALIAS
576 },
577
578 {
579         "invalid_column_reference", ERRCODE_INVALID_COLUMN_REFERENCE
580 },
581
582 {
583         "invalid_column_definition", ERRCODE_INVALID_COLUMN_DEFINITION
584 },
585
586 {
587         "invalid_cursor_definition", ERRCODE_INVALID_CURSOR_DEFINITION
588 },
589
590 {
591         "invalid_database_definition", ERRCODE_INVALID_DATABASE_DEFINITION
592 },
593
594 {
595         "invalid_function_definition", ERRCODE_INVALID_FUNCTION_DEFINITION
596 },
597
598 {
599         "invalid_prepared_statement_definition", ERRCODE_INVALID_PSTATEMENT_DEFINITION
600 },
601
602 {
603         "invalid_schema_definition", ERRCODE_INVALID_SCHEMA_DEFINITION
604 },
605
606 {
607         "invalid_table_definition", ERRCODE_INVALID_TABLE_DEFINITION
608 },
609
610 {
611         "invalid_object_definition", ERRCODE_INVALID_OBJECT_DEFINITION
612 },
613
614 {
615         "with_check_option_violation", ERRCODE_WITH_CHECK_OPTION_VIOLATION
616 },
617
618 {
619         "insufficient_resources", ERRCODE_INSUFFICIENT_RESOURCES
620 },
621
622 {
623         "disk_full", ERRCODE_DISK_FULL
624 },
625
626 {
627         "out_of_memory", ERRCODE_OUT_OF_MEMORY
628 },
629
630 {
631         "too_many_connections", ERRCODE_TOO_MANY_CONNECTIONS
632 },
633
634 {
635         "program_limit_exceeded", ERRCODE_PROGRAM_LIMIT_EXCEEDED
636 },
637
638 {
639         "statement_too_complex", ERRCODE_STATEMENT_TOO_COMPLEX
640 },
641
642 {
643         "too_many_columns", ERRCODE_TOO_MANY_COLUMNS
644 },
645
646 {
647         "too_many_arguments", ERRCODE_TOO_MANY_ARGUMENTS
648 },
649
650 {
651         "object_not_in_prerequisite_state", ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE
652 },
653
654 {
655         "object_in_use", ERRCODE_OBJECT_IN_USE
656 },
657
658 {
659         "cant_change_runtime_param", ERRCODE_CANT_CHANGE_RUNTIME_PARAM
660 },
661
662 {
663         "lock_not_available", ERRCODE_LOCK_NOT_AVAILABLE
664 },
665
666 {
667         "operator_intervention", ERRCODE_OPERATOR_INTERVENTION
668 },
669
670 {
671         "query_canceled", ERRCODE_QUERY_CANCELED
672 },
673
674 {
675         "admin_shutdown", ERRCODE_ADMIN_SHUTDOWN
676 },
677
678 {
679         "crash_shutdown", ERRCODE_CRASH_SHUTDOWN
680 },
681
682 {
683         "cannot_connect_now", ERRCODE_CANNOT_CONNECT_NOW
684 },
685
686 {
687         "io_error", ERRCODE_IO_ERROR
688 },
689
690 {
691         "undefined_file", ERRCODE_UNDEFINED_FILE
692 },
693
694 {
695         "duplicate_file", ERRCODE_DUPLICATE_FILE
696 },
697
698 {
699         "config_file_error", ERRCODE_CONFIG_FILE_ERROR
700 },
701
702 {
703         "lock_file_exists", ERRCODE_LOCK_FILE_EXISTS
704 },
705
706 {
707         "plpgsql_error", ERRCODE_PLPGSQL_ERROR
708 },
709
710 {
711         "raise_exception", ERRCODE_RAISE_EXCEPTION
712 },
713
714 {
715         "internal_error", ERRCODE_INTERNAL_ERROR
716 },
717
718 {
719         "data_corrupted", ERRCODE_DATA_CORRUPTED
720 },
721
722 {
723         "index_corrupted", ERRCODE_INDEX_CORRUPTED
724 },