root/traduc/branches/bv747/manuel/errcodes.sgml

Revision 114, 20.7 kB (checked in by gleu, 3 years ago)

Relecture d'Hervé Dumont.

Line 
1 <!-- $Header: /var/lib/cvs/pgsql-fr/sgml/errcodes.sgml,v 1.2.2.1 2005/03/20 22:34:40 guillaume Exp $ -->
2
3 <appendix id="errcodes-appendix">
4  <title>Codes d'erreurs de <productname>PostgreSQL</productname></title>
5
6  <indexterm zone="errcodes-appendix">
7   <primary>codes d'erreurs</primary>
8   <secondary>liste de</secondary>
9  </indexterm>
10
11  <para>
12   Tous les messages émis par le serveur <productname>PostgreSQL</productname>
13   se voient affectés des codes d'erreur sur cinq caractères suivant les
14   conventions du standard SQL pour les codes <quote>SQLSTATE</>. Les
15   applications qui ont besoin de savoir quelle condition d'erreur est
16   survenue devraient normalement tester le code d'erreur plutôt que de chercher
17   le message d'erreur textuel. Les codes d'erreurs sont moins sujets à
18   changement suivant les versions de <productname>PostgreSQL</productname> et ne
19   sont pas sujets aux changements dû à la localisation des messages d'erreurs.
20  </para>
21
22  <para>
23   Suivant le standard, les deux premiers caractères d'un code d'erreur dénote
24   une classe d'erreurs alors que les trois derniers indiquent une condition
25   spécifique à l'intérieur de cette classe. Du coup, une application ne
26   reconnaissant pas le code d'erreur spécifique pourrait toujours être capable
27   d'inférer ce qu'il convient de faire d'après la classe de l'erreur.
28  </para>
29
30  <para>
31   <xref linkend="errcodes-table"> liste tous les codes d'erreurs définis dans
32   <productname>PostgreSQL</productname> &version;. (Certains ne sont pas
33   réellement utilisés mais sont définis par le standard SQL.) Les classes
34   d'erreurs sont aussi affichées. Pour chaque classe d'erreur, il y a un code
35   d'erreur <quote>standard</> ayant les trois derniers caractères
36   <literal>000</>. Ce code est utilisé seulement pour les conditions d'erreurs
37   qui tombent dans la classe mais n'ont pas de code plus spécifique affecté.
38  </para>
39
40
41 <!--
42  The following table should correspond to the contents of
43  src/include/utils/errcodes.h.
44 -->
45
46 <table id="errcodes-table">
47  <title>Codes d'erreurs <productname>PostgreSQL</productname></title>
48
49  <tgroup cols="2">
50   <thead>
51    <row>
52     <entry>Code d'erreur</entry>
53     <entry>Signification</entry>
54    </row>
55   </thead>
56
57   <tbody>
58
59 <row>
60 <entry>Class 00</entry>
61 <entry>Successful Completion</entry>
62 </row>
63
64 <row>
65 <entry><literal>00000</literal></entry>
66 <entry>SUCCESSFUL COMPLETION</entry>
67 </row>
68
69 <row>
70 <entry>Class 01</entry>
71 <entry>Warning</entry>
72 </row>
73
74 <row>
75 <entry><literal>01000</literal></entry>
76 <entry>WARNING</entry>
77 </row>
78
79 <row>
80 <entry><literal>0100C</literal></entry>
81 <entry>WARNING DYNAMIC RESULT SETS RETURNED</entry>
82 </row>
83
84 <row>
85 <entry><literal>01008</literal></entry>
86 <entry>WARNING IMPLICIT ZERO BIT PADDING</entry>
87 </row>
88
89 <row>
90 <entry><literal>01003</literal></entry>
91 <entry>WARNING NULL VALUE ELIMINATED IN SET FUNCTION</entry>
92 </row>
93
94 <row>
95 <entry><literal>01004</literal></entry>
96 <entry>WARNING STRING DATA RIGHT TRUNCATION</entry>
97 </row>
98
99
100 <row>
101 <entry>Class 02</entry>
102 <entry>No Data --- this is also a warning class per SQL99</entry>
103 </row>
104
105 <row>
106 <entry><literal>02000</literal></entry>
107 <entry>NO DATA</entry>
108 </row>
109
110 <row>
111 <entry><literal>02001</literal></entry>
112 <entry>NO ADDITIONAL DYNAMIC RESULT SETS RETURNED</entry>
113 </row>
114
115
116 <row>
117 <entry>Class 03</entry>
118 <entry>SQL Statement Not Yet Complete</entry>
119 </row>
120
121 <row>
122 <entry><literal>03000</literal></entry>
123 <entry>SQL STATEMENT NOT YET COMPLETE</entry>
124 </row>
125
126
127 <row>
128 <entry>Class 08</entry>
129 <entry>Connection Exception</entry>
130 </row>
131
132 <row>
133 <entry><literal>08000</literal></entry>
134 <entry>CONNECTION EXCEPTION</entry>
135 </row>
136
137 <row>
138 <entry><literal>08003</literal></entry>
139 <entry>CONNECTION DOES NOT EXIST</entry>
140 </row>
141
142 <row>
143 <entry><literal>08006</literal></entry>
144 <entry>CONNECTION FAILURE</entry>
145 </row>
146
147 <row>
148 <entry><literal>08001</literal></entry>
149 <entry>SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION</entry>
150 </row>
151
152 <row>
153 <entry><literal>08004</literal></entry>
154 <entry>SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION</entry>
155 </row>
156
157 <row>
158 <entry><literal>08007</literal></entry>
159 <entry>TRANSACTION RESOLUTION UNKNOWN</entry>
160 </row>
161
162 <row>
163 <entry><literal>08P01</literal></entry>
164 <entry>PROTOCOL VIOLATION</entry>
165 </row>
166
167
168 <row>
169 <entry>Class 09</entry>
170 <entry>Triggered Action Exception</entry>
171 </row>
172
173 <row>
174 <entry><literal>09000</literal></entry>
175 <entry>TRIGGERED ACTION EXCEPTION</entry>
176 </row>
177
178
179 <row>
180 <entry>Class 0A</entry>
181 <entry>Feature Not Supported</entry>
182 </row>
183
184 <row>
185 <entry><literal>0A000</literal></entry>
186 <entry>FEATURE NOT SUPPORTED</entry>
187 </row>
188
189
190 <row>
191 <entry>Class 0B</entry>
192 <entry>Invalid Transaction Initiation</entry>
193 </row>
194
195 <row>
196 <entry><literal>0B000</literal></entry>
197 <entry>INVALID TRANSACTION INITIATION</entry>
198 </row>
199
200
201 <row>
202 <entry>Class 0F</entry>
203 <entry>Locator Exception</entry>
204 </row>
205
206 <row>
207 <entry><literal>0F000</literal></entry>
208 <entry>LOCATOR EXCEPTION</entry>
209 </row>
210
211 <row>
212 <entry><literal>0F001</literal></entry>
213 <entry>INVALID SPECIFICATION</entry>
214 </row>
215
216
217 <row>
218 <entry>Class 0L</entry>
219 <entry>Invalid Grantor</entry>
220 </row>
221
222 <row>
223 <entry><literal>0L000</literal></entry>
224 <entry>INVALID GRANTOR</entry>
225 </row>
226
227 <row>
228 <entry><literal>0LP01</literal></entry>
229 <entry>INVALID GRANT OPERATION</entry>
230 </row>
231
232
233 <row>
234 <entry>Class 0P</entry>
235 <entry>Invalid Role Specification</entry>
236 </row>
237
238 <row>
239 <entry><literal>0P000</literal></entry>
240 <entry>INVALID ROLE SPECIFICATION</entry>
241 </row>
242
243
244 <row>
245 <entry>Class 21</entry>
246 <entry>Cardinality Violation</entry>
247 </row>
248
249 <row>
250 <entry><literal>21000</literal></entry>
251 <entry>CARDINALITY VIOLATION</entry>
252 </row>
253
254
255 <row>
256 <entry>Class 22</entry>
257 <entry>Data Exception</entry>
258 </row>
259
260 <row>
261 <entry><literal>22000</literal></entry>
262 <entry>DATA EXCEPTION</entry>
263 </row>
264
265 <row>
266 <entry><literal>2202E</literal></entry>
267 <entry>ARRAY ELEMENT ERROR</entry>
268 </row>
269
270 <row>
271 <entry><literal>22021</literal></entry>
272 <entry>CHARACTER NOT IN REPERTOIRE</entry>
273 </row>
274
275 <row>
276 <entry><literal>22008</literal></entry>
277 <entry>DATETIME FIELD OVERFLOW</entry>
278 </row>
279
280 <row>
281 <entry><literal>22012</literal></entry>
282 <entry>DIVISION BY ZERO</entry>
283 </row>
284
285 <row>
286 <entry><literal>22005</literal></entry>
287 <entry>ERROR IN ASSIGNMENT</entry>
288 </row>
289
290 <row>
291 <entry><literal>2200B</literal></entry>
292 <entry>ESCAPE CHARACTER CONFLICT</entry>
293 </row>
294
295 <row>
296 <entry><literal>22022</literal></entry>
297 <entry>INDICATOR OVERFLOW</entry>
298 </row>
299
300 <row>
301 <entry><literal>22015</literal></entry>
302 <entry>INTERVAL FIELD OVERFLOW</entry>
303 </row>
304
305 <row>
306 <entry><literal>22018</literal></entry>
307 <entry>INVALID CHARACTER VALUE FOR CAST</entry>
308 </row>
309
310 <row>
311 <entry><literal>22007</literal></entry>
312 <entry>INVALID DATETIME FORMAT</entry>
313 </row>
314
315 <row>
316 <entry><literal>22019</literal></entry>
317 <entry>INVALID ESCAPE CHARACTER</entry>
318 </row>
319
320 <row>
321 <entry><literal>2200D</literal></entry>
322 <entry>INVALID ESCAPE OCTET</entry>
323 </row>
324
325 <row>
326 <entry><literal>22025</literal></entry>
327 <entry>INVALID ESCAPE SEQUENCE</entry>
328 </row>
329
330 <row>
331 <entry><literal>22010</literal></entry>
332 <entry>INVALID INDICATOR PARAMETER VALUE</entry>
333 </row>
334
335 <row>
336 <entry><literal>22020</literal></entry>
337 <entry>INVALID LIMIT VALUE</entry>
338 </row>
339
340 <row>
341 <entry><literal>22023</literal></entry>
342 <entry>INVALID PARAMETER VALUE</entry>
343 </row>
344
345 <row>
346 <entry><literal>2201B</literal></entry>
347 <entry>INVALID REGULAR EXPRESSION</entry>
348 </row>
349
350 <row>
351 <entry><literal>22009</literal></entry>
352 <entry>INVALID TIME ZONE DISPLACEMENT VALUE</entry>
353 </row>
354
355 <row>
356 <entry><literal>2200C</literal></entry>
357 <entry>INVALID USE OF ESCAPE CHARACTER</entry>
358 </row>
359
360 <row>
361 <entry><literal>2200G</literal></entry>
362 <entry>MOST SPECIFIC TYPE MISMATCH</entry>
363 </row>
364
365 <row>
366 <entry><literal>22004</literal></entry>
367 <entry>NULL VALUE NOT ALLOWED</entry>
368 </row>
369
370 <row>
371 <entry><literal>22002</literal></entry>
372 <entry>NULL VALUE NO INDICATOR PARAMETER</entry>
373 </row>
374
375 <row>
376 <entry><literal>22003</literal></entry>
377 <entry>NUMERIC VALUE OUT OF RANGE</entry>
378 </row>
379
380 <row>
381 <entry><literal>22026</literal></entry>
382 <entry>STRING DATA LENGTH MISMATCH</entry>
383 </row>
384
385 <row>
386 <entry><literal>22001</literal></entry>
387 <entry>STRING DATA RIGHT TRUNCATION</entry>
388 </row>
389
390 <row>
391 <entry><literal>22011</literal></entry>
392 <entry>SUBSTRING ERROR</entry>
393 </row>
394
395 <row>
396 <entry><literal>22027</literal></entry>
397 <entry>TRIM ERROR</entry>
398 </row>
399
400 <row>
401 <entry><literal>22024</literal></entry>
402 <entry>UNTERMINATED C STRING</entry>
403 </row>
404
405 <row>
406 <entry><literal>2200F</literal></entry>
407 <entry>ZERO LENGTH CHARACTER STRING</entry>
408 </row>
409
410 <row>
411 <entry><literal>22P01</literal></entry>
412 <entry>FLOATING POINT EXCEPTION</entry>
413 </row>
414
415 <row>
416 <entry><literal>22P02</literal></entry>
417 <entry>INVALID TEXT REPRESENTATION</entry>
418 </row>
419
420 <row>
421 <entry><literal>22P03</literal></entry>
422 <entry>INVALID BINARY REPRESENTATION</entry>
423 </row>
424
425 <row>
426 <entry><literal>22P04</literal></entry>
427 <entry>BAD COPY FILE FORMAT</entry>
428 </row>
429
430 <row>
431 <entry><literal>22P05</literal></entry>
432 <entry>UNTRANSLATABLE CHARACTER</entry>
433 </row>
434
435
436 <row>
437 <entry>Class 23</entry>
438 <entry>Integrity Constraint Violation</entry>
439 </row>
440
441 <row>
442 <entry><literal>23000</literal></entry>
443 <entry>INTEGRITY CONSTRAINT VIOLATION</entry>
444 </row>
445
446 <row>
447 <entry><literal>23001</literal></entry>
448 <entry>RESTRICT VIOLATION</entry>
449 </row>
450
451 <row>
452 <entry><literal>23502</literal></entry>
453 <entry>NOT NULL VIOLATION</entry>
454 </row>
455
456 <row>
457 <entry><literal>23503</literal></entry>
458 <entry>FOREIGN KEY VIOLATION</entry>
459 </row>
460
461 <row>
462 <entry><literal>23505</literal></entry>
463 <entry>UNIQUE VIOLATION</entry>
464 </row>
465
466 <row>
467 <entry><literal>23514</literal></entry>
468 <entry>CHECK VIOLATION</entry>
469 </row>
470
471
472 <row>
473 <entry>Class 24</entry>
474 <entry>Invalid Cursor State</entry>
475 </row>
476
477 <row>
478 <entry><literal>24000</literal></entry>
479 <entry>INVALID CURSOR STATE</entry>
480 </row>
481
482
483 <row>
484 <entry>Class 25</entry>
485 <entry>Invalid Transaction State</entry>
486 </row>
487
488 <row>
489 <entry><literal>25000</literal></entry>
490 <entry>INVALID TRANSACTION STATE</entry>
491 </row>
492
493 <row>
494 <entry><literal>25001</literal></entry>
495 <entry>ACTIVE SQL TRANSACTION</entry>
496 </row>
497
498 <row>
499 <entry><literal>25002</literal></entry>
500 <entry>BRANCH TRANSACTION ALREADY ACTIVE</entry>
501 </row>
502
503 <row>
504 <entry><literal>25008</literal></entry>
505 <entry>HELD CURSOR REQUIRES SAME ISOLATION LEVEL</entry>
506 </row>
507
508 <row>
509 <entry><literal>25003</literal></entry>
510 <entry>INAPPROPRIATE ACCESS MODE FOR BRANCH TRANSACTION</entry>
511 </row>
512
513 <row>
514 <entry><literal>25004</literal></entry>
515 <entry>INAPPROPRIATE ISOLATION LEVEL FOR BRANCH TRANSACTION</entry>
516 </row>
517
518 <row>
519 <entry><literal>25005</literal></entry>
520 <entry>NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION</entry>
521 </row>
522
523 <row>
524 <entry><literal>25006</literal></entry>
525 <entry>READ ONLY SQL TRANSACTION</entry>
526 </row>
527
528 <row>
529 <entry><literal>25007</literal></entry>
530 <entry>SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED</entry>
531 </row>
532
533 <row>
534 <entry><literal>25P01</literal></entry>
535 <entry>NO ACTIVE SQL TRANSACTION</entry>
536 </row>
537
538 <row>
539 <entry><literal>25P02</literal></entry>
540 <entry>IN FAILED SQL TRANSACTION</entry>
541 </row>
542
543
544 <row>
545 <entry>Class 26</entry>
546 <entry>Invalid SQL Statement Name</entry>
547 </row>
548
549 <row>
550 <entry><literal>26000</literal></entry>
551 <entry>INVALID SQL STATEMENT NAME</entry>
552 </row>
553
554
555 <row>
556 <entry>Class 27</entry>
557 <entry>Triggered Data Change Violation</entry>
558 </row>
559
560 <row>
561 <entry><literal>27000</literal></entry>
562 <entry>TRIGGERED DATA CHANGE VIOLATION</entry>
563 </row>
564
565
566 <row>
567 <entry>Class 28</entry>
568 <entry>Invalid Authorization Specification</entry>
569 </row>
570
571 <row>
572 <entry><literal>28000</literal></entry>
573 <entry>INVALID AUTHORIZATION SPECIFICATION</entry>
574 </row>
575
576
577 <row>
578 <entry>Class 2B</entry>
579 <entry>Dependent Privilege Descriptors Still Exist</entry>
580 </row>
581
582 <row>
583 <entry><literal>2B000</literal></entry>
584 <entry>DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST</entry>
585 </row>
586
587 <row>
588 <entry><literal>2BP01</literal></entry>
589 <entry>DEPENDENT OBJECTS STILL EXIST</entry>
590 </row>
591
592
593 <row>
594 <entry>Class 2D</entry>
595 <entry>Invalid Transaction Termination</entry>
596 </row>
597
598 <row>
599 <entry><literal>2D000</literal></entry>
600 <entry>INVALID TRANSACTION TERMINATION</entry>
601 </row>
602
603
604 <row>
605 <entry>Class 2F</entry>
606 <entry>SQL Routine Exception</entry>
607 </row>
608
609 <row>
610 <entry><literal>2F000</literal></entry>
611 <entry>SQL ROUTINE EXCEPTION</entry>
612 </row>
613
614 <row>
615 <entry><literal>2F005</literal></entry>
616 <entry>FUNCTION EXECUTED NO RETURN STATEMENT</entry>
617 </row>
618
619 <row>
620 <entry><literal>2F002</literal></entry>
621 <entry>MODIFYING SQL DATA NOT PERMITTED</entry>
622 </row>
623
624 <row>
625 <entry><literal>2F003</literal></entry>
626 <entry>PROHIBITED SQL STATEMENT ATTEMPTED</entry>
627 </row>
628
629 <row>
630 <entry><literal>2F004</literal></entry>
631 <entry>READING SQL DATA NOT PERMITTED</entry>
632 </row>
633
634
635 <row>
636 <entry>Class 34</entry>
637 <entry>Invalid Cursor Name</entry>
638 </row>
639
640 <row>
641 <entry><literal>34000</literal></entry>
642 <entry>INVALID CURSOR NAME</entry>
643 </row>
644
645
646 <row>
647 <entry>Class 38</entry>
648 <entry>External Routine Exception</entry>
649 </row>
650
651 <row>
652 <entry><literal>38000</literal></entry>
653 <entry>EXTERNAL ROUTINE EXCEPTION</entry>
654 </row>
655
656 <row>
657 <entry><literal>38001</literal></entry>
658 <entry>CONTAINING SQL NOT PERMITTED</entry>
659 </row>
660
661 <row>
662 <entry><literal>38002</literal></entry>
663 <entry>MODIFYING SQL DATA NOT PERMITTED</entry>
664 </row>
665
666 <row>
667 <entry><literal>38003</literal></entry>
668 <entry>PROHIBITED SQL STATEMENT ATTEMPTED</entry>
669 </row>
670
671 <row>
672 <entry><literal>38004</literal></entry>
673 <entry>READING SQL DATA NOT PERMITTED</entry>
674 </row>
675
676
677 <row>
678 <entry>Class 39</entry>
679 <entry>External Routine Invocation Exception</entry>
680 </row>
681
682 <row>
683 <entry><literal>39000</literal></entry>
684 <entry>EXTERNAL ROUTINE INVOCATION EXCEPTION</entry>
685 </row>
686
687 <row>
688 <entry><literal>39001</literal></entry>
689 <entry>INVALID SQLSTATE RETURNED</entry>
690 </row>
691
692 <row>
693 <entry><literal>39004</literal></entry>
694 <entry>NULL VALUE NOT ALLOWED</entry>
695 </row>
696
697 <row>
698 <entry><literal>39P01</literal></entry>
699 <entry>TRIGGER PROTOCOL VIOLATED</entry>
700 </row>
701
702 <row>
703 <entry><literal>39P02</literal></entry>
704 <entry>SRF PROTOCOL VIOLATED</entry>
705 </row>
706
707
708 <row>
709 <entry>Class 3D</entry>
710 <entry>Invalid Catalog Name</entry>
711 </row>
712
713 <row>
714 <entry><literal>3D000</literal></entry>
715 <entry>INVALID CATALOG NAME</entry>
716 </row>
717
718
719 <row>
720 <entry>Class 3F</entry>
721 <entry>Invalid Schema Name</entry>
722 </row>
723
724 <row>
725 <entry><literal>3F000</literal></entry>
726 <entry>INVALID SCHEMA NAME</entry>
727 </row>
728
729
730 <row>
731 <entry>Class 40</entry>
732 <entry>Transaction Rollback</entry>
733 </row>
734
735 <row>
736 <entry><literal>40000</literal></entry>
737 <entry>TRANSACTION ROLLBACK</entry>
738 </row>
739
740 <row>
741 <entry><literal>40002</literal></entry>
742 <entry>INTEGRITY CONSTRAINT VIOLATION</entry>
743 </row>
744
745 <row>
746 <entry><literal>40001</literal></entry>
747 <entry>SERIALIZATION FAILURE</entry>
748 </row>
749
750 <row>
751 <entry><literal>40003</literal></entry>
752 <entry>STATEMENT COMPLETION UNKNOWN</entry>
753 </row>
754
755 <row>
756 <entry><literal>40P01</literal></entry>
757 <entry>DEADLOCK DETECTED</entry>
758 </row>
759
760
761 <row>
762 <entry>Class 42</entry>
763 <entry>Syntax Error or Access Rule Violation</entry>
764 </row>
765
766 <row>
767 <entry><literal>42000</literal></entry>
768 <entry>SYNTAX ERROR OR ACCESS RULE VIOLATION</entry>
769 </row>
770
771 <row>
772 <entry><literal>42601</literal></entry>
773 <entry>SYNTAX ERROR</entry>
774 </row>
775
776 <row>
777 <entry><literal>42501</literal></entry>
778 <entry>INSUFFICIENT PRIVILEGE</entry>
779 </row>
780
781 <row>
782 <entry><literal>42846</literal></entry>
783 <entry>CANNOT COERCE</entry>
784 </row>
785
786 <row>
787 <entry><literal>42803</literal></entry>
788 <entry>GROUPING ERROR</entry>
789 </row>
790
791 <row>
792 <entry><literal>42830</literal></entry>
793 <entry>INVALID FOREIGN KEY</entry>
794 </row>
795
796 <row>
797 <entry><literal>42602</literal></entry>
798 <entry>INVALID NAME</entry>
799 </row>
800
801 <row>
802 <entry><literal>42622</literal></entry>
803 <entry>NAME TOO LONG</entry>
804 </row>
805
806 <row>
807 <entry><literal>42939</literal></entry>
808 <entry>RESERVED NAME</entry>
809 </row>
810
811 <row>
812 <entry><literal>42804</literal></entry>
813 <entry>DATATYPE MISMATCH</entry>
814 </row>
815
816 <row>
817 <entry><literal>42P18</literal></entry>
818 <entry>INDETERMINATE DATATYPE</entry>
819 </row>
820
821 <row>
822 <entry><literal>42809</literal></entry>
823 <entry>WRONG OBJECT TYPE</entry>
824 </row>
825
826 <row>
827 <entry><literal>42703</literal></entry>
828 <entry>UNDEFINED COLUMN</entry>
829 </row>
830
831 <row>
832 <entry><literal>42883</literal></entry>
833 <entry>UNDEFINED FUNCTION</entry>
834 </row>
835
836 <row>
837 <entry><literal>42P01</literal></entry>
838 <entry>UNDEFINED TABLE</entry>
839 </row>
840
841 <row>
842 <entry><literal>42P02</literal></entry>
843 <entry>UNDEFINED PARAMETER</entry>
844 </row>
845
846 <row>
847 <entry><literal>42704</literal></entry>
848 <entry>UNDEFINED OBJECT</entry>
849 </row>
850
851 <row>
852 <entry><literal>42701</literal></entry>
853 <entry>DUPLICATE COLUMN</entry>
854 </row>
855
856 <row>
857 <entry><literal>42P03</literal></entry>
858 <entry>DUPLICATE CURSOR</entry>
859 </row>
860
861 <row>
862 <entry><literal>42P04</literal></entry>
863 <entry>DUPLICATE DATABASE</entry>
864 </row>
865
866 <row>
867 <entry><literal>42723</literal></entry>
868 <entry>DUPLICATE FUNCTION</entry>
869 </row>
870
871 <row>
872 <entry><literal>42P05</literal></entry>
873 <entry>DUPLICATE PSTATEMENT</entry>
874 </row>
875
876 <row>
877 <entry><literal>42P06</literal></entry>
878 <entry>DUPLICATE SCHEMA</entry>
879 </row>
880
881 <row>
882 <entry><literal>42P07</literal></entry>
883 <entry>DUPLICATE TABLE</entry>
884 </row>
885
886 <row>
887 <entry><literal>42712</literal></entry>
888 <entry>DUPLICATE ALIAS</entry>
889 </row>
890
891 <row>
892 <entry><literal>42710</literal></entry>
893 <entry>DUPLICATE OBJECT</entry>
894 </row>
895
896 <row>
897 <entry><literal>42702</literal></entry>
898 <entry>AMBIGUOUS COLUMN</entry>
899 </row>
900
901 <row>
902 <entry><literal>42725</literal></entry>
903 <entry>AMBIGUOUS FUNCTION</entry>
904 </row>
905
906 <row>
907 <entry><literal>42P08</literal></entry>
908 <entry>AMBIGUOUS PARAMETER</entry>
909 </row>
910
911 <row>
912 <entry><literal>42P09</literal></entry>
913 <entry>AMBIGUOUS ALIAS</entry>
914 </row>
915
916 <row>
917 <entry><literal>42P10</literal></entry>
918 <entry>INVALID COLUMN REFERENCE</entry>
919 </row>
920
921 <row>
922 <entry><literal>42611</literal></entry>
923 <entry>INVALID COLUMN DEFINITION</entry>
924 </row>
925
926 <row>
927 <entry><literal>42P11</literal></entry>
928 <entry>INVALID CURSOR DEFINITION</entry>
929 </row>
930
931 <row>
932 <entry><literal>42P12</literal></entry>
933 <entry>INVALID DATABASE DEFINITION</entry>
934 </row>
935
936 <row>
937 <entry><literal>42P13</literal></entry>
938 <entry>INVALID FUNCTION DEFINITION</entry>
939 </row>
940
941 <row>
942 <entry><literal>42P14</literal></entry>
943 <entry>INVALID PSTATEMENT DEFINITION</entry>
944 </row>
945
946 <row>
947 <entry><literal>42P15</literal></entry>
948 <entry>INVALID SCHEMA DEFINITION</entry>
949 </row>
950
951 <row>
952 <entry><literal>42P16</literal></entry>
953 <entry>INVALID TABLE DEFINITION</entry>
954 </row>
955
956 <row>
957 <entry><literal>42P17</literal></entry>
958 <entry>INVALID OBJECT DEFINITION</entry>
959 </row>
960
961
962 <row>
963 <entry>Class 44</entry>
964 <entry>WITH CHECK OPTION Violation</entry>
965 </row>
966
967 <row>
968 <entry><literal>44000</literal></entry>
969 <entry>WITH CHECK OPTION VIOLATION</entry>
970 </row>
971
972
973 <row>
974 <entry>Class 53</entry>
975 <entry>Insufficient Resources</entry>
976 </row>
977
978 <row>
979 <entry><literal>53000</literal></entry>
980 <entry>INSUFFICIENT RESOURCES</entry>
981 </row>
982
983 <row>
984 <entry><literal>53100</literal></entry>
985 <entry>DISK FULL</entry>
986 </row>
987
988 <row>
989 <entry><literal>53200</literal></entry>
990 <entry>OUT OF MEMORY</entry>
991 </row>
992
993 <row>
994 <entry><literal>53300</literal></entry>
995 <entry>TOO MANY CONNECTIONS</entry>
996 </row>
997
998
999 <row>
1000 <entry>Class 54</entry>
1001 <entry>Program Limit Exceeded</entry>
1002 </row>
1003
1004 <row>
1005 <entry><literal>54000</literal></entry>
1006 <entry>PROGRAM LIMIT EXCEEDED</entry>
1007 </row>
1008
1009 <row>
1010 <entry><literal>54001</literal></entry>
1011 <entry>STATEMENT TOO COMPLEX</entry>
1012 </row>
1013
1014 <row>
1015 <entry><literal>54011</literal></entry>
1016 <entry>TOO MANY COLUMNS</entry>
1017 </row>
1018
1019 <row>
1020 <entry><literal>54023</literal></entry>
1021 <entry>TOO MANY ARGUMENTS</entry>
1022 </row>
1023
1024
1025 <row>
1026 <entry>Class 55</entry>
1027 <entry>Object Not In Prerequisite State</entry>
1028 </row>
1029
1030 <row>
1031 <entry><literal>55000</literal></entry>
1032 <entry>OBJECT NOT IN PREREQUISITE STATE</entry>
1033 </row>
1034
1035 <row>
1036 <entry><literal>55006</literal></entry>
1037 <entry>OBJECT IN USE</entry>
1038 </row>
1039
1040 <row>
1041 <entry><literal>55P02</literal></entry>
1042 <entry>CANT CHANGE RUNTIME PARAM</entry>
1043 </row>
1044
1045
1046 <row>
1047 <entry>Class 57</entry>
1048 <entry>Operator Intervention</entry>
1049 </row>
1050
1051 <row>
1052 <entry><literal>57000</literal></entry>
1053 <entry>OPERATOR INTERVENTION</entry>
1054 </row>
1055
1056 <row>
1057 <entry><literal>57014</literal></entry>
1058 <entry>QUERY CANCELED</entry>
1059 </row>
1060
1061 <row>
1062 <entry><literal>57P01</literal></entry>
1063 <entry>ADMIN SHUTDOWN</entry>
1064 </row>
1065
1066 <row>
1067 <entry><literal>57P02</literal></entry>
1068 <entry>CRASH SHUTDOWN</entry>
1069 </row>
1070
1071 <row>
1072 <entry><literal>57P03</literal></entry>
1073 <entry>CANNOT CONNECT NOW</entry>
1074 </row>
1075
1076
1077 <row>
1078 <entry>Class 58</entry>
1079 <entry>System Error (errors external to PostgreSQL itself)</entry>
1080 </row>
1081
1082 <row>
1083 <entry><literal>58030</literal></entry>
1084 <entry>IO ERROR</entry>
1085 </row>
1086
1087 <row>
1088 <entry><literal>58P01</literal></entry>
1089 <entry>UNDEFINED FILE</entry>
1090 </row>
1091
1092 <row>
1093 <entry><literal>58P02</literal></entry>
1094 <entry>DUPLICATE FILE</entry>
1095 </row>
1096
1097
1098 <row>
1099 <entry>Class F0</entry>
1100 <entry>Configuration File Error</entry>
1101 </row>
1102
1103 <row>
1104 <entry><literal>F0000</literal></entry>
1105 <entry>CONFIG FILE ERROR</entry>
1106 </row>
1107
1108 <row>
1109 <entry><literal>F0001</literal></entry>
1110 <entry>LOCK FILE EXISTS</entry>
1111 </row>
1112
1113
1114 <row>
1115 <entry>Class XX</entry>
1116 <entry>Internal Error</entry>
1117 </row>
1118
1119 <row>
1120 <entry><literal>XX000</literal></entry>
1121 <entry>INTERNAL ERROR</entry>
1122 </row>
1123
1124 <row>
1125 <entry><literal>XX001</literal></entry>
1126 <entry>DATA CORRUPTED</entry>
1127 </row>
1128
1129 <row>
1130 <entry><literal>XX002</literal></entry>
1131 <entry>INDEX CORRUPTED</entry>
1132 </row>
1133
1134   </tbody>
1135  </tgroup>
1136 </table>
1137
1138
1139 </appendix>
1140
1141
1142
1143
1144
Note: See TracBrowser for help on using the browser.