Re: plperl error format vs plpgsql error format vs pgTAP - Mailing list pgsql-hackers

From Tom Lane
Subject Re: plperl error format vs plpgsql error format vs pgTAP
Date
Msg-id 441.1243545344@sss.pgh.pa.us
Whole thread Raw
In response to Re: plperl error format vs plpgsql error format vs pgTAP  (Kevin Field <kevinjamesfield@gmail.com>)
List pgsql-hackers
Kevin Field <kevinjamesfield@gmail.com> writes:
> I wanted to use the SQLSTATE code, but it's always XX000.  If there
> were some way to set it when calling elog()

ereport?

http://developer.postgresql.org/pgdocs/postgres/error-message-reporting.html

At the plpgsql level, since 8.4 you can specify a SQLSTATE in RAISE.
AFAIR nobody's gotten round to doing anything about it in plperl.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: PostgreSQL Developer meeting minutes up
Next
From: "David E. Wheeler"
Date:
Subject: Re: plperl error format vs plpgsql error format vs pgTAP