[SQL] pl/pgsql and error handling

2008-02-28 Thread Alex Hochberger
Is it possible to grab access to the actually user-friendly error message? I have a bunch of files that come into my database, each slightly different. The submitter fills out a form that records the info, and sticks it into a table. If the file is malformed (wrong number of columns in a

Re: [SQL] pl/pgsql and error handling

2008-02-28 Thread Tom Lane
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

Re: [SQL] pl/pgsql and error handling

2008-02-28 Thread Alex Hochberger
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

Re: [SQL] pl/pgsql and error handling

2008-02-28 Thread Bart Degryse
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?