www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING would be the place to look.
>>> Alex Hochberger <[EMAIL PROTECTED]> 2008-02-29 6:29 >>> I do not know. It's sounds like the Oracle PL/SQL behavior is what I want. Does PostgreSQL's pl/pgsql have such a feature? It's not in the documentation anywhere. I'll check it from the office tomorrow. Alex On Feb 28, 2008, at 11:43 PM, Tom Lane wrote: > Alex Hochberger <[EMAIL PROTECTED]> writes: >> Is it possible to grab access to the actually user-friendly error >> message? > > Doesn't the SQLERRM variable do what you want? > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org ( > http://archives.postgresql.org/ ) ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
