On Sunday 01 July 2007 21:50, Tom Lane wrote:
> Why would you expect it to? The raise_exception SQLSTATE applies
> specifically and solely to the plpgsql RAISE command. The entire
> point of those identifiers is to match fairly narrow classes of
> exceptions, not anything thrown by anyone.
>
> IMHO the real problem with both RAISE and the plperl elog command
> is there's no way to specify which SQLSTATE to throw. In the case
> of the elog command I think you just get a default.
I expected it to, because I told elog what kind of errorlevel to give me, but
apparently that does not influence the SQLSTATE. I didn't know it didn't apply
to procedures in other languages.