On Sat, 2005-01-01 at 14:10 -0500, Tom Lane wrote: <blockquote type="CITE"><pre>
<font color="#000000">Korry <<a href="mailto:korry@starband.net">korry@starband.net</a>> writes:</font>
<font color="#000000">> It seems you can’t trap every condition listed in errocodes-</font>
<font color="#000000">> appendix.html; in particular, you can’t trap SUCCESSFUL_COMPLETION, any</font>
<font color="#000000">> of the conditions listed in the WARNING category, or any of the</font>
<font color="#000000">> conditions listed in the NO DATA category. (At least through 8.0 rc1 -</font>
<font color="#000000">> I haven't checked in later versions).</font>
<font color="#000000">Those aren't errors.</font>
</pre></blockquote><br /> Right. Just trying to clarify the issue for the person that asked the question. <br /><br
/>The pl/pgSQL documentation (37.7.5) says:<br /><br /> > The <tt>condition</tt> names can be any of those shown in
<ahref="file:///usr/local/pg800b5/doc/postgresql/html/errcodes-appendix.html">Appendix A</a>.<br /><br /> As you say,
notall of the conditions listed in Appendix A are error conditions. Perhaps 37.7.5 should be changed to clarify?
Withoutlooking at plerrcodes.h, you can't find a definitive list.<br /><br /><br /> -- Korry<br /><br />