Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting sqlstate in plpgsql function - Mailing list pgsql-admin

From Tom Lane
Subject Re: Setting sqlstate in plpgsql function
Date
Msg-id 15165.1175881528@sss.pgh.pa.us
Whole thread Raw
In response to Setting sqlstate in plpgsql function  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
Tree view 
"Chris Hoover" <revoohc@gmail.com> writes:
> Is where anyway to set the sqlstate to a custom value when inside a plpgsql
> function?

Nope :-(.  There's been some discussion of extending plpgsql's RAISE
command to allow specification of a SQLSTATE, but nothing's been done.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Setting sqlstate in plpgsql function
Next
From: Ray Stell
Date:
Subject: alter user log entry, too much information ;)