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.
