Re: pl/pgsql and error handling - Mailing list pgsql-sql

From Bart Degryse
Subject Re: pl/pgsql and error handling
Date
Msg-id 47C7C5D3.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Re: pl/pgsql and error handling  (Alex Hochberger <alex@dsgi.us>)
List 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 by date:

Previous
From: Alex Hochberger
Date:
Subject: Re: pl/pgsql and error handling
Next
From: "Professor Flávio Brito"
Date:
Subject: Function returns error (view) (RESOLVED)