Re: pl/pgsql and error handling
От | Bart Degryse |
---|---|
Тема | Re: pl/pgsql and error handling |
Дата | |
Msg-id | 47C7C5D3.A3DD.0030.0@indicator.be обсуждение исходный текст |
Ответ на | Re: pl/pgsql and error handling (Alex Hochberger <alex@dsgi.us>) |
Список | pgsql-sql |
<a href="http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING">www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING</a> wouldbe the place to look.<br /><br />>>> Alex Hochberger <alex@dsgi.us> 2008-02-29 6:29 >>><br />Ido not know. It's sounds like the Oracle PL/SQL behavior is what I <br />want. Does PostgreSQL's pl/pgsql have sucha feature? It's not in <br />the documentation anywhere. I'll check it from the office tomorrow.<br /><br />Alex<br/><br />On Feb 28, 2008, at 11:43 PM, Tom Lane wrote:<br /><br />> Alex Hochberger <alex@dsgi.us> writes:<br/>>> Is it possible to grab access to the actually user-friendly error<br />>> message?<br />><br/>> Doesn't the SQLERRM variable do what you want?<br />><br />> regards, tom lane<br />><br />>---------------------------(end of <br />> broadcast)---------------------------<br />> TIP 4: Have you searchedour list archives?<br />><br />> <a href="http://archives.postgresql.org/">http://archives.postgresql.org</a><br/><br /><br />---------------------------(endof broadcast)---------------------------<br />TIP 7: You can help support the PostgreSQLproject by donating at<br /><br /> <a href="http://www.postgresql.org/about/donate">http://www.postgresql.org/about/donate</a><br/>
В списке pgsql-sql по дате отправления: