1<!-- autogenerated from src/backend/utils/errcodes.txt, do not edit --> 2 3 4<row> 5 <entry spanname="span12"><emphasis role="bold">Class 00 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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 — 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