1<!-- autogenerated from src/backend/utils/errcodes.txt, do not edit -->
2
3
4<row>
5 <entry spanname="span12"><emphasis role="bold">Class 00 &mdash; Successful Completion</></entry>
6</row>
7
8<row>
9 <entry><literal>00000</literal></entry>
10 <entry><symbol>successful_completion</symbol></entry>
11</row>
12
13
14<row>
15 <entry spanname="span12"><emphasis role="bold">Class 01 &mdash; Warning</></entry>
16</row>
17
18<row>
19 <entry><literal>01000</literal></entry>
20 <entry><symbol>warning</symbol></entry>
21</row>
22
23<row>
24 <entry><literal>0100C</literal></entry>
25 <entry><symbol>dynamic_result_sets_returned</symbol></entry>
26</row>
27
28<row>
29 <entry><literal>01008</literal></entry>
30 <entry><symbol>implicit_zero_bit_padding</symbol></entry>
31</row>
32
33<row>
34 <entry><literal>01003</literal></entry>
35 <entry><symbol>null_value_eliminated_in_set_function</symbol></entry>
36</row>
37
38<row>
39 <entry><literal>01007</literal></entry>
40 <entry><symbol>privilege_not_granted</symbol></entry>
41</row>
42
43<row>
44 <entry><literal>01006</literal></entry>
45 <entry><symbol>privilege_not_revoked</symbol></entry>
46</row>
47
48<row>
49 <entry><literal>01004</literal></entry>
50 <entry><symbol>string_data_right_truncation</symbol></entry>
51</row>
52
53<row>
54 <entry><literal>01P01</literal></entry>
55 <entry><symbol>deprecated_feature</symbol></entry>
56</row>
57
58
59<row>
60 <entry spanname="span12"><emphasis role="bold">Class 02 &mdash; No Data (this is also a warning class per the SQL standard)</></entry>
61</row>
62
63<row>
64 <entry><literal>02000</literal></entry>
65 <entry><symbol>no_data</symbol></entry>
66</row>
67
68<row>
69 <entry><literal>02001</literal></entry>
70 <entry><symbol>no_additional_dynamic_result_sets_returned</symbol></entry>
71</row>
72
73
74<row>
75 <entry spanname="span12"><emphasis role="bold">Class 03 &mdash; SQL Statement Not Yet Complete</></entry>
76</row>
77
78<row>
79 <entry><literal>03000</literal></entry>
80 <entry><symbol>sql_statement_not_yet_complete</symbol></entry>
81</row>
82
83
84<row>
85 <entry spanname="span12"><emphasis role="bold">Class 08 &mdash; Connection Exception</></entry>
86</row>
87
88<row>
89 <entry><literal>08000</literal></entry>
90 <entry><symbol>connection_exception</symbol></entry>
91</row>
92
93<row>
94 <entry><literal>08003</literal></entry>
95 <entry><symbol>connection_does_not_exist</symbol></entry>
96</row>
97
98<row>
99 <entry><literal>08006</literal></entry>
100 <entry><symbol>connection_failure</symbol></entry>
101</row>
102
103<row>
104 <entry><literal>08001</literal></entry>
105 <entry><symbol>sqlclient_unable_to_establish_sqlconnection</symbol></entry>
106</row>
107
108<row>
109 <entry><literal>08004</literal></entry>
110 <entry><symbol>sqlserver_rejected_establishment_of_sqlconnection</symbol></entry>
111</row>
112
113<row>
114 <entry><literal>08007</literal></entry>
115 <entry><symbol>transaction_resolution_unknown</symbol></entry>
116</row>
117
118<row>
119 <entry><literal>08P01</literal></entry>
120 <entry><symbol>protocol_violation</symbol></entry>
121</row>
122
123
124<row>
125 <entry spanname="span12"><emphasis role="bold">Class 09 &mdash; Triggered Action Exception</></entry>
126</row>
127
128<row>
129 <entry><literal>09000</literal></entry>
130 <entry><symbol>triggered_action_exception</symbol></entry>
131</row>
132
133
134<row>
135 <entry spanname="span12"><emphasis role="bold">Class 0A &mdash; Feature Not Supported</></entry>
136</row>
137
138<row>
139 <entry><literal>0A000</literal></entry>
140 <entry><symbol>feature_not_supported</symbol></entry>
141</row>
142
143
144<row>
145 <entry spanname="span12"><emphasis role="bold">Class 0B &mdash; Invalid Transaction Initiation</></entry>
146</row>
147
148<row>
149 <entry><literal>0B000</literal></entry>
150 <entry><symbol>invalid_transaction_initiation</symbol></entry>
151</row>
152
153
154<row>
155 <entry spanname="span12"><emphasis role="bold">Class 0F &mdash; Locator Exception</></entry>
156</row>
157
158<row>
159 <entry><literal>0F000</literal></entry>
160 <entry><symbol>locator_exception</symbol></entry>
161</row>
162
163<row>
164 <entry><literal>0F001</literal></entry>
165 <entry><symbol>invalid_locator_specification</symbol></entry>
166</row>
167
168
169<row>
170 <entry spanname="span12"><emphasis role="bold">Class 0L &mdash; Invalid Grantor</></entry>
171</row>
172
173<row>
174 <entry><literal>0L000</literal></entry>
175 <entry><symbol>invalid_grantor</symbol></entry>
176</row>
177
178<row>
179 <entry><literal>0LP01</literal></entry>
180 <entry><symbol>invalid_grant_operation</symbol></entry>
181</row>
182
183
184<row>
185 <entry spanname="span12"><emphasis role="bold">Class 0P &mdash; Invalid Role Specification</></entry>
186</row>
187
188<row>
189 <entry><literal>0P000</literal></entry>
190 <entry><symbol>invalid_role_specification</symbol></entry>
191</row>
192
193
194<row>
195 <entry spanname="span12"><emphasis role="bold">Class 0Z &mdash; Diagnostics Exception</></entry>
196</row>
197
198<row>
199 <entry><literal>0Z000</literal></entry>
200 <entry><symbol>diagnostics_exception</symbol></entry>
201</row>
202
203<row>
204 <entry><literal>0Z002</literal></entry>
205 <entry><symbol>stacked_diagnostics_accessed_without_active_handler</symbol></entry>
206</row>
207
208
209<row>
210 <entry spanname="span12"><emphasis role="bold">Class 20 &mdash; Case Not Found</></entry>
211</row>
212
213<row>
214 <entry><literal>20000</literal></entry>
215 <entry><symbol>case_not_found</symbol></entry>
216</row>
217
218
219<row>
220 <entry spanname="span12"><emphasis role="bold">Class 21 &mdash; Cardinality Violation</></entry>
221</row>
222
223<row>
224 <entry><literal>21000</literal></entry>
225 <entry><symbol>cardinality_violation</symbol></entry>
226</row>
227
228
229<row>
230 <entry spanname="span12"><emphasis role="bold">Class 22 &mdash; Data Exception</></entry>
231</row>
232
233<row>
234 <entry><literal>22000</literal></entry>
235 <entry><symbol>data_exception</symbol></entry>
236</row>
237
238<row>
239 <entry><literal>2202E</literal></entry>
240 <entry><symbol>array_subscript_error</symbol></entry>
241</row>
242
243<row>
244 <entry><literal>22021</literal></entry>
245 <entry><symbol>character_not_in_repertoire</symbol></entry>
246</row>
247
248<row>
249 <entry><literal>22008</literal></entry>
250 <entry><symbol>datetime_field_overflow</symbol></entry>
251</row>
252
253<row>
254 <entry><literal>22012</literal></entry>
255 <entry><symbol>division_by_zero</symbol></entry>
256</row>
257
258<row>
259 <entry><literal>22005</literal></entry>
260 <entry><symbol>error_in_assignment</symbol></entry>
261</row>
262
263<row>
264 <entry><literal>2200B</literal></entry>
265 <entry><symbol>escape_character_conflict</symbol></entry>
266</row>
267
268<row>
269 <entry><literal>22022</literal></entry>
270 <entry><symbol>indicator_overflow</symbol></entry>
271</row>
272
273<row>
274 <entry><literal>22015</literal></entry>
275 <entry><symbol>interval_field_overflow</symbol></entry>
276</row>
277
278<row>
279 <entry><literal>2201E</literal></entry>
280 <entry><symbol>invalid_argument_for_logarithm</symbol></entry>
281</row>
282
283<row>
284 <entry><literal>22014</literal></entry>
285 <entry><symbol>invalid_argument_for_ntile_function</symbol></entry>
286</row>
287
288<row>
289 <entry><literal>22016</literal></entry>
290 <entry><symbol>invalid_argument_for_nth_value_function</symbol></entry>
291</row>
292
293<row>
294 <entry><literal>2201F</literal></entry>
295 <entry><symbol>invalid_argument_for_power_function</symbol></entry>
296</row>
297
298<row>
299 <entry><literal>2201G</literal></entry>
300 <entry><symbol>invalid_argument_for_width_bucket_function</symbol></entry>
301</row>
302
303<row>
304 <entry><literal>22018</literal></entry>
305 <entry><symbol>invalid_character_value_for_cast</symbol></entry>
306</row>
307
308<row>
309 <entry><literal>22007</literal></entry>
310 <entry><symbol>invalid_datetime_format</symbol></entry>
311</row>
312
313<row>
314 <entry><literal>22019</literal></entry>
315 <entry><symbol>invalid_escape_character</symbol></entry>
316</row>
317
318<row>
319 <entry><literal>2200D</literal></entry>
320 <entry><symbol>invalid_escape_octet</symbol></entry>
321</row>
322
323<row>
324 <entry><literal>22025</literal></entry>
325 <entry><symbol>invalid_escape_sequence</symbol></entry>
326</row>
327
328<row>
329 <entry><literal>22P06</literal></entry>
330 <entry><symbol>nonstandard_use_of_escape_character</symbol></entry>
331</row>
332
333<row>
334 <entry><literal>22010</literal></entry>
335 <entry><symbol>invalid_indicator_parameter_value</symbol></entry>
336</row>
337
338<row>
339 <entry><literal>22023</literal></entry>
340 <entry><symbol>invalid_parameter_value</symbol></entry>
341</row>
342
343<row>
344 <entry><literal>2201B</literal></entry>
345 <entry><symbol>invalid_regular_expression</symbol></entry>
346</row>
347
348<row>
349 <entry><literal>2201W</literal></entry>
350 <entry><symbol>invalid_row_count_in_limit_clause</symbol></entry>
351</row>
352
353<row>
354 <entry><literal>2201X</literal></entry>
355 <entry><symbol>invalid_row_count_in_result_offset_clause</symbol></entry>
356</row>
357
358<row>
359 <entry><literal>22009</literal></entry>
360 <entry><symbol>invalid_time_zone_displacement_value</symbol></entry>
361</row>
362
363<row>
364 <entry><literal>2200C</literal></entry>
365 <entry><symbol>invalid_use_of_escape_character</symbol></entry>
366</row>
367
368<row>
369 <entry><literal>2200G</literal></entry>
370 <entry><symbol>most_specific_type_mismatch</symbol></entry>
371</row>
372
373<row>
374 <entry><literal>22004</literal></entry>
375 <entry><symbol>null_value_not_allowed</symbol></entry>
376</row>
377
378<row>
379 <entry><literal>22002</literal></entry>
380 <entry><symbol>null_value_no_indicator_parameter</symbol></entry>
381</row>
382
383<row>
384 <entry><literal>22003</literal></entry>
385 <entry><symbol>numeric_value_out_of_range</symbol></entry>
386</row>
387
388<row>
389 <entry><literal>22026</literal></entry>
390 <entry><symbol>string_data_length_mismatch</symbol></entry>
391</row>
392
393<row>
394 <entry><literal>22001</literal></entry>
395 <entry><symbol>string_data_right_truncation</symbol></entry>
396</row>
397
398<row>
399 <entry><literal>22011</literal></entry>
400 <entry><symbol>substring_error</symbol></entry>
401</row>
402
403<row>
404 <entry><literal>22027</literal></entry>
405 <entry><symbol>trim_error</symbol></entry>
406</row>
407
408<row>
409 <entry><literal>22024</literal></entry>
410 <entry><symbol>unterminated_c_string</symbol></entry>
411</row>
412
413<row>
414 <entry><literal>2200F</literal></entry>
415 <entry><symbol>zero_length_character_string</symbol></entry>
416</row>
417
418<row>
419 <entry><literal>22P01</literal></entry>
420 <entry><symbol>floating_point_exception</symbol></entry>
421</row>
422
423<row>
424 <entry><literal>22P02</literal></entry>
425 <entry><symbol>invalid_text_representation</symbol></entry>
426</row>
427
428<row>
429 <entry><literal>22P03</literal></entry>
430 <entry><symbol>invalid_binary_representation</symbol></entry>
431</row>
432
433<row>
434 <entry><literal>22P04</literal></entry>
435 <entry><symbol>bad_copy_file_format</symbol></entry>
436</row>
437
438<row>
439 <entry><literal>22P05</literal></entry>
440 <entry><symbol>untranslatable_character</symbol></entry>
441</row>
442
443<row>
444 <entry><literal>2200L</literal></entry>
445 <entry><symbol>not_an_xml_document</symbol></entry>
446</row>
447
448<row>
449 <entry><literal>2200M</literal></entry>
450 <entry><symbol>invalid_xml_document</symbol></entry>
451</row>
452
453<row>
454 <entry><literal>2200N</literal></entry>
455 <entry><symbol>invalid_xml_content</symbol></entry>
456</row>
457
458<row>
459 <entry><literal>2200S</literal></entry>
460 <entry><symbol>invalid_xml_comment</symbol></entry>
461</row>
462
463<row>
464 <entry><literal>2200T</literal></entry>
465 <entry><symbol>invalid_xml_processing_instruction</symbol></entry>
466</row>
467
468
469<row>
470 <entry spanname="span12"><emphasis role="bold">Class 23 &mdash; Integrity Constraint Violation</></entry>
471</row>
472
473<row>
474 <entry><literal>23000</literal></entry>
475 <entry><symbol>integrity_constraint_violation</symbol></entry>
476</row>
477
478<row>
479 <entry><literal>23001</literal></entry>
480 <entry><symbol>restrict_violation</symbol></entry>
481</row>
482
483<row>
484 <entry><literal>23502</literal></entry>
485 <entry><symbol>not_null_violation</symbol></entry>
486</row>
487
488<row>
489 <entry><literal>23503</literal></entry>
490 <entry><symbol>foreign_key_violation</symbol></entry>
491</row>
492
493<row>
494 <entry><literal>23505</literal></entry>
495 <entry><symbol>unique_violation</symbol></entry>
496</row>
497
498<row>
499 <entry><literal>23514</literal></entry>
500 <entry><symbol>check_violation</symbol></entry>
501</row>
502
503<row>
504 <entry><literal>23P01</literal></entry>
505 <entry><symbol>exclusion_violation</symbol></entry>
506</row>
507
508
509<row>
510 <entry spanname="span12"><emphasis role="bold">Class 24 &mdash; Invalid Cursor State</></entry>
511</row>
512
513<row>
514 <entry><literal>24000</literal></entry>
515 <entry><symbol>invalid_cursor_state</symbol></entry>
516</row>
517
518
519<row>
520 <entry spanname="span12"><emphasis role="bold">Class 25 &mdash; Invalid Transaction State</></entry>
521</row>
522
523<row>
524 <entry><literal>25000</literal></entry>
525 <entry><symbol>invalid_transaction_state</symbol></entry>
526</row>
527
528<row>
529 <entry><literal>25001</literal></entry>
530 <entry><symbol>active_sql_transaction</symbol></entry>
531</row>
532
533<row>
534 <entry><literal>25002</literal></entry>
535 <entry><symbol>branch_transaction_already_active</symbol></entry>
536</row>
537
538<row>
539 <entry><literal>25008</literal></entry>
540 <entry><symbol>held_cursor_requires_same_isolation_level</symbol></entry>
541</row>
542
543<row>
544 <entry><literal>25003</literal></entry>
545 <entry><symbol>inappropriate_access_mode_for_branch_transaction</symbol></entry>
546</row>
547
548<row>
549 <entry><literal>25004</literal></entry>
550 <entry><symbol>inappropriate_isolation_level_for_branch_transaction</symbol></entry>
551</row>
552
553<row>
554 <entry><literal>25005</literal></entry>
555 <entry><symbol>no_active_sql_transaction_for_branch_transaction</symbol></entry>
556</row>
557
558<row>
559 <entry><literal>25006</literal></entry>
560 <entry><symbol>read_only_sql_transaction</symbol></entry>
561</row>
562
563<row>
564 <entry><literal>25007</literal></entry>
565 <entry><symbol>schema_and_data_statement_mixing_not_supported</symbol></entry>
566</row>
567
568<row>
569 <entry><literal>25P01</literal></entry>
570 <entry><symbol>no_active_sql_transaction</symbol></entry>
571</row>
572
573<row>
574 <entry><literal>25P02</literal></entry>
575 <entry><symbol>in_failed_sql_transaction</symbol></entry>
576</row>
577
578
579<row>
580 <entry spanname="span12"><emphasis role="bold">Class 26 &mdash; Invalid SQL Statement Name</></entry>
581</row>
582
583<row>
584 <entry><literal>26000</literal></entry>
585 <entry><symbol>invalid_sql_statement_name</symbol></entry>
586</row>
587
588
589<row>
590 <entry spanname="span12"><emphasis role="bold">Class 27 &mdash; Triggered Data Change Violation</></entry>
591</row>
592
593<row>
594 <entry><literal>27000</literal></entry>
595 <entry><symbol>triggered_data_change_violation</symbol></entry>
596</row>
597
598
599<row>
600 <entry spanname="span12"><emphasis role="bold">Class 28 &mdash; Invalid Authorization Specification</></entry>
601</row>
602
603<row>
604 <entry><literal>28000</literal></entry>
605 <entry><symbol>invalid_authorization_specification</symbol></entry>
606</row>
607
608<row>
609 <entry><literal>28P01</literal></entry>
610 <entry><symbol>invalid_password</symbol></entry>
611</row>
612
613
614<row>
615 <entry spanname="span12"><emphasis role="bold">Class 2B &mdash; Dependent Privilege Descriptors Still Exist</></entry>
616</row>
617
618<row>
619 <entry><literal>2B000</literal></entry>
620 <entry><symbol>dependent_privilege_descriptors_still_exist</symbol></entry>
621</row>
622
623<row>
624 <entry><literal>2BP01</literal></entry>
625 <entry><symbol>dependent_objects_still_exist</symbol></entry>
626</row>
627
628
629<row>
630 <entry spanname="span12"><emphasis role="bold">Class 2D &mdash; Invalid Transaction Termination</></entry>
631</row>
632
633<row>
634 <entry><literal>2D000</literal></entry>
635 <entry><symbol>invalid_transaction_termination</symbol></entry>
636</row>
637
638
639<row>
640 <entry spanname="span12"><emphasis role="bold">Class 2F &mdash; SQL Routine Exception</></entry>
641</row>
642
643<row>
644 <entry><literal>2F000</literal></entry>
645 <entry><symbol>sql_routine_exception</symbol></entry>
646</row>
647
648<row>
649 <entry><literal>2F005</literal></entry>
650 <entry><symbol>function_executed_no_return_statement</symbol></entry>
651</row>
652
653<row>
654 <entry><literal>2F002</literal></entry>
655 <entry><symbol>modifying_sql_data_not_permitted</symbol></entry>
656</row>
657
658<row>
659 <entry><literal>2F003</literal></entry>
660 <entry><symbol>prohibited_sql_statement_attempted</symbol></entry>
661</row>
662
663<row>
664 <entry><literal>2F004</literal></entry>
665 <entry><symbol>reading_sql_data_not_permitted</symbol></entry>
666</row>
667
668
669<row>
670 <entry spanname="span12"><emphasis role="bold">Class 34 &mdash; Invalid Cursor Name</></entry>
671</row>
672
673<row>
674 <entry><literal>34000</literal></entry>
675 <entry><symbol>invalid_cursor_name</symbol></entry>
676</row>
677
678
679<row>
680 <entry spanname="span12"><emphasis role="bold">Class 38 &mdash; External Routine Exception</></entry>
681</row>
682
683<row>
684 <entry><literal>38000</literal></entry>
685 <entry><symbol>external_routine_exception</symbol></entry>
686</row>
687
688<row>
689 <entry><literal>38001</literal></entry>
690 <entry><symbol>containing_sql_not_permitted</symbol></entry>
691</row>
692
693<row>
694 <entry><literal>38002</literal></entry>
695 <entry><symbol>modifying_sql_data_not_permitted</symbol></entry>
696</row>
697
698<row>
699 <entry><literal>38003</literal></entry>
700 <entry><symbol>prohibited_sql_statement_attempted</symbol></entry>
701</row>
702
703<row>
704 <entry><literal>38004</literal></entry>
705 <entry><symbol>reading_sql_data_not_permitted</symbol></entry>
706</row>
707
708
709<row>
710 <entry spanname="span12"><emphasis role="bold">Class 39 &mdash; External Routine Invocation Exception</></entry>
711</row>
712
713<row>
714 <entry><literal>39000</literal></entry>
715 <entry><symbol>external_routine_invocation_exception</symbol></entry>
716</row>
717
718<row>
719 <entry><literal>39001</literal></entry>
720 <entry><symbol>invalid_sqlstate_returned</symbol></entry>
721</row>
722
723<row>
724 <entry><literal>39004</literal></entry>
725 <entry><symbol>null_value_not_allowed</symbol></entry>
726</row>
727
728<row>
729 <entry><literal>39P01</literal></entry>
730 <entry><symbol>trigger_protocol_violated</symbol></entry>
731</row>
732
733<row>
734 <entry><literal>39P02</literal></entry>
735 <entry><symbol>srf_protocol_violated</symbol></entry>
736</row>
737
738
739<row>
740 <entry spanname="span12"><emphasis role="bold">Class 3B &mdash; Savepoint Exception</></entry>
741</row>
742
743<row>
744 <entry><literal>3B000</literal></entry>
745 <entry><symbol>savepoint_exception</symbol></entry>
746</row>
747
748<row>
749 <entry><literal>3B001</literal></entry>
750 <entry><symbol>invalid_savepoint_specification</symbol></entry>
751</row>
752
753
754<row>
755 <entry spanname="span12"><emphasis role="bold">Class 3D &mdash; Invalid Catalog Name</></entry>
756</row>
757
758<row>
759 <entry><literal>3D000</literal></entry>
760 <entry><symbol>invalid_catalog_name</symbol></entry>
761</row>
762
763
764<row>
765 <entry spanname="span12"><emphasis role="bold">Class 3F &mdash; Invalid Schema Name</></entry>
766</row>
767
768<row>
769 <entry><literal>3F000</literal></entry>
770 <entry><symbol>invalid_schema_name</symbol></entry>
771</row>
772
773
774<row>
775 <entry spanname="span12"><emphasis role="bold">Class 40 &mdash; Transaction Rollback</></entry>
776</row>
777
778<row>
779 <entry><literal>40000</literal></entry>
780 <entry><symbol>transaction_rollback</symbol></entry>
781</row>
782
783<row>
784 <entry><literal>40002</literal></entry>
785 <entry><symbol>transaction_integrity_constraint_violation</symbol></entry>
786</row>
787
788<row>
789 <entry><literal>40001</literal></entry>
790 <entry><symbol>serialization_failure</symbol></entry>
791</row>
792
793<row>
794 <entry><literal>40003</literal></entry>
795 <entry><symbol>statement_completion_unknown</symbol></entry>
796</row>
797
798<row>
799 <entry><literal>40P01</literal></entry>
800 <entry><symbol>deadlock_detected</symbol></entry>
801</row>
802
803
804<row>
805 <entry spanname="span12"><emphasis role="bold">Class 42 &mdash; Syntax Error or Access Rule Violation</></entry>
806</row>
807
808<row>
809 <entry><literal>42000</literal></entry>
810 <entry><symbol>syntax_error_or_access_rule_violation</symbol></entry>
811</row>
812
813<row>
814 <entry><literal>42601</literal></entry>
815 <entry><symbol>syntax_error</symbol></entry>
816</row>
817
818<row>
819 <entry><literal>42501</literal></entry>
820 <entry><symbol>insufficient_privilege</symbol></entry>
821</row>
822
823<row>
824 <entry><literal>42846</literal></entry>
825 <entry><symbol>cannot_coerce</symbol></entry>
826</row>
827
828<row>
829 <entry><literal>42803</literal></entry>
830 <entry><symbol>grouping_error</symbol></entry>
831</row>
832
833<row>
834 <entry><literal>42P20</literal></entry>
835 <entry><symbol>windowing_error</symbol></entry>
836</row>
837
838<row>
839 <entry><literal>42P19</literal></entry>
840 <entry><symbol>invalid_recursion</symbol></entry>
841</row>
842
843<row>
844 <entry><literal>42830</literal></entry>
845 <entry><symbol>invalid_foreign_key</symbol></entry>
846</row>
847
848<row>
849 <entry><literal>42602</literal></entry>
850 <entry><symbol>invalid_name</symbol></entry>
851</row>
852
853<row>
854 <entry><literal>42622</literal></entry>
855 <entry><symbol>name_too_long</symbol></entry>
856</row>
857
858<row>
859 <entry><literal>42939</literal></entry>
860 <entry><symbol>reserved_name</symbol></entry>
861</row>
862
863<row>
864 <entry><literal>42804</literal></entry>
865 <entry><symbol>datatype_mismatch</symbol></entry>
866</row>
867
868<row>
869 <entry><literal>42P18</literal></entry>
870 <entry><symbol>indeterminate_datatype</symbol></entry>
871</row>
872
873<row>
874 <entry><literal>42P21</literal></entry>
875 <entry><symbol>collation_mismatch</symbol></entry>
876</row>
877
878<row>
879 <entry><literal>42P22</literal></entry>
880 <entry><symbol>indeterminate_collation</symbol></entry>
881</row>
882
883<row>
884 <entry><literal>42809</literal></entry>
885 <entry><symbol>wrong_object_type</symbol></entry>
886</row>
887
888<row>
889 <entry><literal>42703</literal></entry>
890 <entry><symbol>undefined_column</symbol></entry>
891</row>
892
893<row>
894 <entry><literal>42883</literal></entry>
895 <entry><symbol>undefined_function</symbol></entry>
896</row>
897
898<row>
899 <entry><literal>42P01</literal></entry>
900 <entry><symbol>undefined_table</symbol></entry>
901</row>
902
903<row>
904 <entry><literal>42P02</literal></entry>
905 <entry><symbol>undefined_parameter</symbol></entry>
906</row>
907
908<row>
909 <entry><literal>42704</literal></entry>
910 <entry><symbol>undefined_object</symbol></entry>
911</row>
912
913<row>
914 <entry><literal>42701</literal></entry>
915 <entry><symbol>duplicate_column</symbol></entry>
916</row>
917
918<row>
919 <entry><literal>42P03</literal></entry>
920 <entry><symbol>duplicate_cursor</symbol></entry>
921</row>
922
923<row>
924 <entry><literal>42P04</literal></entry>
925 <entry><symbol>duplicate_database</symbol></entry>
926</row>
927
928<row>
929 <entry><literal>42723</literal></entry>
930 <entry><symbol>duplicate_function</symbol></entry>
931</row>
932
933<row>
934 <entry><literal>42P05</literal></entry>
935 <entry><symbol>duplicate_prepared_statement</symbol></entry>
936</row>
937
938<row>
939 <entry><literal>42P06</literal></entry>
940 <entry><symbol>duplicate_schema</symbol></entry>
941</row>
942
943<row>
944 <entry><literal>42P07</literal></entry>
945 <entry><symbol>duplicate_table</symbol></entry>
946</row>
947
948<row>
949 <entry><literal>42712</literal></entry>
950 <entry><symbol>duplicate_alias</symbol></entry>
951</row>
952
953<row>
954 <entry><literal>42710</literal></entry>
955 <entry><symbol>duplicate_object</symbol></entry>
956</row>
957
958<row>
959 <entry><literal>42702</literal></entry>
960 <entry><symbol>ambiguous_column</symbol></entry>
961</row>
962
963<row>
964 <entry><literal>42725</literal></entry>
965 <entry><symbol>ambiguous_function</symbol></entry>
966</row>
967
968<row>
969 <entry><literal>42P08</literal></entry>
970 <entry><symbol>ambiguous_parameter</symbol></entry>
971</row>
972
973<row>
974 <entry><literal>42P09</literal></entry>
975 <entry><symbol>ambiguous_alias</symbol></entry>
976</row>
977
978<row>
979 <entry><literal>42P10</literal></entry>
980 <entry><symbol>invalid_column_reference</symbol></entry>
981</row>
982
983<row>
984 <entry><literal>42611</literal></entry>
985 <entry><symbol>invalid_column_definition</symbol></entry>
986</row>
987
988<row>
989 <entry><literal>42P11</literal></entry>
990 <entry><symbol>invalid_cursor_definition</symbol></entry>
991</row>
992
993<row>
994 <entry><literal>42P12</literal></entry>
995 <entry><symbol>invalid_database_definition</symbol></entry>
996</row>
997
998<row>
999 <entry><literal>42P13</literal></entry>
1000 <entry><symbol>invalid_function_definition</symbol></entry>
1001</row>
1002
1003<row>
1004 <entry><literal>42P14</literal></entry>
1005 <entry><symbol>invalid_prepared_statement_definition</symbol></entry>
1006</row>
1007
1008<row>
1009 <entry><literal>42P15</literal></entry>
1010 <entry><symbol>invalid_schema_definition</symbol></entry>
1011</row>
1012
1013<row>
1014 <entry><literal>42P16</literal></entry>
1015 <entry><symbol>invalid_table_definition</symbol></entry>
1016</row>
1017
1018<row>
1019 <entry><literal>42P17</literal></entry>
1020 <entry><symbol>invalid_object_definition</symbol></entry>
1021</row>
1022
1023
1024<row>
1025 <entry spanname="span12"><emphasis role="bold">Class 44 &mdash; WITH CHECK OPTION Violation</></entry>
1026</row>
1027
1028<row>
1029 <entry><literal>44000</literal></entry>
1030 <entry><symbol>with_check_option_violation</symbol></entry>
1031</row>
1032
1033
1034<row>
1035 <entry spanname="span12"><emphasis role="bold">Class 53 &mdash; Insufficient Resources</></entry>
1036</row>
1037
1038<row>
1039 <entry><literal>53000</literal></entry>
1040 <entry><symbol>insufficient_resources</symbol></entry>
1041</row>
1042
1043<row>
1044 <entry><literal>53100</literal></entry>
1045 <entry><symbol>disk_full</symbol></entry>
1046</row>
1047
1048<row>
1049 <entry><literal>53200</literal></entry>
1050 <entry><symbol>out_of_memory</symbol></entry>
1051</row>
1052
1053<row>
1054 <entry><literal>53300</literal></entry>
1055 <entry><symbol>too_many_connections</symbol></entry>
1056</row>
1057
1058<row>
1059 <entry><literal>53400</literal></entry>
1060 <entry><symbol>configuration_limit_exceeded</symbol></entry>
1061</row>
1062
1063
1064<row>
1065 <entry spanname="span12"><emphasis role="bold">Class 54 &mdash; Program Limit Exceeded</></entry>
1066</row>
1067
1068<row>
1069 <entry><literal>54000</literal></entry>
1070 <entry><symbol>program_limit_exceeded</symbol></entry>
1071</row>
1072
1073<row>
1074 <entry><literal>54001</literal></entry>
1075 <entry><symbol>statement_too_complex</symbol></entry>
1076</row>
1077
1078<row>
1079 <entry><literal>54011</literal></entry>
1080 <entry><symbol>too_many_columns</symbol></entry>
1081</row>
1082
1083<row>
1084 <entry><literal>54023</literal></entry>
1085 <entry><symbol>too_many_arguments</symbol></entry>
1086</row>
1087
1088
1089<row>
1090 <entry spanname="span12"><emphasis role="bold">Class 55 &mdash; Object Not In Prerequisite State</></entry>
1091</row>
1092
1093<row>
1094 <entry><literal>55000</literal></entry>
1095 <entry><symbol>object_not_in_prerequisite_state</symbol></entry>
1096</row>
1097
1098<row>
1099 <entry><literal>55006</literal></entry>
1100 <entry><symbol>object_in_use</symbol></entry>
1101</row>
1102
1103<row>
1104 <entry><literal>55P02</literal></entry>
1105 <entry><symbol>cant_change_runtime_param</symbol></entry>
1106</row>
1107
1108<row>
1109 <entry><literal>55P03</literal></entry>
1110 <entry><symbol>lock_not_available</symbol></entry>
1111</row>
1112
1113
1114<row>
1115 <entry spanname="span12"><emphasis role="bold">Class 57 &mdash; Operator Intervention</></entry>
1116</row>
1117
1118<row>
1119 <entry><literal>57000</literal></entry>
1120 <entry><symbol>operator_intervention</symbol></entry>
1121</row>
1122
1123<row>
1124 <entry><literal>57014</literal></entry>
1125 <entry><symbol>query_canceled</symbol></entry>
1126</row>
1127
1128<row>
1129 <entry><literal>57P01</literal></entry>
1130 <entry><symbol>admin_shutdown</symbol></entry>
1131</row>
1132
1133<row>
1134 <entry><literal>57P02</literal></entry>
1135 <entry><symbol>crash_shutdown</symbol></entry>
1136</row>
1137
1138<row>
1139 <entry><literal>57P03</literal></entry>
1140 <entry><symbol>cannot_connect_now</symbol></entry>
1141</row>
1142
1143<row>
1144 <entry><literal>57P04</literal></entry>
1145 <entry><symbol>database_dropped</symbol></entry>
1146</row>
1147
1148
1149<row>
1150 <entry spanname="span12"><emphasis role="bold">Class 58 &mdash; System Error (errors external to <productname>PostgreSQL</> itself)</></entry>
1151</row>
1152
1153<row>
1154 <entry><literal>58000</literal></entry>
1155 <entry><symbol>system_error</symbol></entry>
1156</row>
1157
1158<row>
1159 <entry><literal>58030</literal></entry>
1160 <entry><symbol>io_error</symbol></entry>
1161</row>
1162
1163<row>
1164 <entry><literal>58P01</literal></entry>
1165 <entry><symbol>undefined_file</symbol></entry>
1166</row>
1167
1168<row>
1169 <entry><literal>58P02</literal></entry>
1170 <entry><symbol>duplicate_file</symbol></entry>
1171</row>
1172
1173
1174<row>
1175 <entry spanname="span12"><emphasis role="bold">Class F0 &mdash; Configuration File Error</></entry>
1176</row>
1177
1178<row>
1179 <entry><literal>F0000</literal></entry>
1180 <entry><symbol>config_file_error</symbol></entry>
1181</row>
1182
1183<row>
1184 <entry><literal>F0001</literal></entry>
1185 <entry><symbol>lock_file_exists</symbol></entry>
1186</row>
1187
1188
1189<row>
1190 <entry spanname="span12"><emphasis role="bold">Class HV &mdash; Foreign Data Wrapper Error (SQL/MED)</></entry>
1191</row>
1192
1193<row>
1194 <entry><literal>HV000</literal></entry>
1195 <entry><symbol>fdw_error</symbol></entry>
1196</row>
1197
1198<row>
1199 <entry><literal>HV005</literal></entry>
1200 <entry><symbol>fdw_column_name_not_found</symbol></entry>
1201</row>
1202
1203<row>
1204 <entry><literal>HV002</literal></entry>
1205 <entry><symbol>fdw_dynamic_parameter_value_needed</symbol></entry>
1206</row>
1207
1208<row>
1209 <entry><literal>HV010</literal></entry>
1210 <entry><symbol>fdw_function_sequence_error</symbol></entry>
1211</row>
1212
1213<row>
1214 <entry><literal>HV021</literal></entry>
1215 <entry><symbol>fdw_inconsistent_descriptor_information</symbol></entry>
1216</row>
1217
1218<row>
1219 <entry><literal>HV024</literal></entry>
1220 <entry><symbol>fdw_invalid_attribute_value</symbol></entry>
1221</row>
1222
1223<row>
1224 <entry><literal>HV007</literal></entry>
1225 <entry><symbol>fdw_invalid_column_name</symbol></entry>
1226</row>
1227
1228<row>
1229 <entry><literal>HV008</literal></entry>
1230 <entry><symbol>fdw_invalid_column_number</symbol></entry>
1231</row>
1232
1233<row>
1234 <entry><literal>HV004</literal></entry>
1235 <entry><symbol>fdw_invalid_data_type</symbol></entry>
1236</row>
1237
1238<row>
1239 <entry><literal>HV006</literal></entry>
1240 <entry><symbol>fdw_invalid_data_type_descriptors</symbol></entry>
1241</row>
1242
1243<row>
1244 <entry><literal>HV091</literal></entry>
1245 <entry><symbol>fdw_invalid_descriptor_field_identifier</symbol></entry>
1246</row>
1247
1248<row>
1249 <entry><literal>HV00B</literal></entry>
1250 <entry><symbol>fdw_invalid_handle</symbol></entry>
1251</row>
1252
1253<row>
1254 <entry><literal>HV00C</literal></entry>
1255 <entry><symbol>fdw_invalid_option_index</symbol></entry>
1256</row>
1257
1258<row>
1259 <entry><literal>HV00D</literal></entry>
1260 <entry><symbol>fdw_invalid_option_name</symbol></entry>
1261</row>
1262
1263<row>
1264 <entry><literal>HV090</literal></entry>
1265 <entry><symbol>fdw_invalid_string_length_or_buffer_length</symbol></entry>
1266</row>
1267
1268<row>
1269 <entry><literal>HV00A</literal></entry>
1270 <entry><symbol>fdw_invalid_string_format</symbol></entry>
1271</row>
1272
1273<row>
1274 <entry><literal>HV009</literal></entry>
1275 <entry><symbol>fdw_invalid_use_of_null_pointer</symbol></entry>
1276</row>
1277
1278<row>
1279 <entry><literal>HV014</literal></entry>
1280 <entry><symbol>fdw_too_many_handles</symbol></entry>
1281</row>
1282
1283<row>
1284 <entry><literal>HV001</literal></entry>
1285 <entry><symbol>fdw_out_of_memory</symbol></entry>
1286</row>
1287
1288<row>
1289 <entry><literal>HV00P</literal></entry>
1290 <entry><symbol>fdw_no_schemas</symbol></entry>
1291</row>
1292
1293<row>
1294 <entry><literal>HV00J</literal></entry>
1295 <entry><symbol>fdw_option_name_not_found</symbol></entry>
1296</row>
1297
1298<row>
1299 <entry><literal>HV00K</literal></entry>
1300 <entry><symbol>fdw_reply_handle</symbol></entry>
1301</row>
1302
1303<row>
1304 <entry><literal>HV00Q</literal></entry>
1305 <entry><symbol>fdw_schema_not_found</symbol></entry>
1306</row>
1307
1308<row>
1309 <entry><literal>HV00R</literal></entry>
1310 <entry><symbol>fdw_table_not_found</symbol></entry>
1311</row>
1312
1313<row>
1314 <entry><literal>HV00L</literal></entry>
1315 <entry><symbol>fdw_unable_to_create_execution</symbol></entry>
1316</row>
1317
1318<row>
1319 <entry><literal>HV00M</literal></entry>
1320 <entry><symbol>fdw_unable_to_create_reply</symbol></entry>
1321</row>
1322
1323<row>
1324 <entry><literal>HV00N</literal></entry>
1325 <entry><symbol>fdw_unable_to_establish_connection</symbol></entry>
1326</row>
1327
1328
1329<row>
1330 <entry spanname="span12"><emphasis role="bold">Class P0 &mdash; PL/pgSQL Error</></entry>
1331</row>
1332
1333<row>
1334 <entry><literal>P0000</literal></entry>
1335 <entry><symbol>plpgsql_error</symbol></entry>
1336</row>
1337
1338<row>
1339 <entry><literal>P0001</literal></entry>
1340 <entry><symbol>raise_exception</symbol></entry>
1341</row>
1342
1343<row>
1344 <entry><literal>P0002</literal></entry>
1345 <entry><symbol>no_data_found</symbol></entry>
1346</row>
1347
1348<row>
1349 <entry><literal>P0003</literal></entry>
1350 <entry><symbol>too_many_rows</symbol></entry>
1351</row>
1352
1353
1354<row>
1355 <entry spanname="span12"><emphasis role="bold">Class XX &mdash; Internal Error</></entry>
1356</row>
1357
1358<row>
1359 <entry><literal>XX000</literal></entry>
1360 <entry><symbol>internal_error</symbol></entry>
1361</row>
1362
1363<row>
1364 <entry><literal>XX001</literal></entry>
1365 <entry><symbol>data_corrupted</symbol></entry>
1366</row>
1367
1368<row>
1369 <entry><literal>XX002</literal></entry>
1370 <entry><symbol>index_corrupted</symbol></entry>
1371</row>
1372