Emi Lu wrote:
<snip> From the page:
"The PL/pgSQL condition name for each error code is the same as the
phrase shown in the table, with underscores substituted for spaces.
For example, code 22012, DIVISION BY ZERO, has condition name
DIVISION_BY_ZERO. Condition names can be written in either upper or
lower case.
(Note that PL/pgSQL does not recognize warning, as opposed to error,
condition names; those are classes 00, 01, and 02.)"
That means pl/pgsql will not recognize error codes under classes 00, 01,
02.
Correct - they are informational rather than errors. I'm not sure what
it would mean to trap "successful completion" for example.
Is there a way, I can output error code?
exception
when ... then
when others then
raise notice '%, %', SQLSTATE, SQLERRM;
But it seems that SQLERRM and SQLSTATE did not work for me. By the way,
I am using postgresql 8.0.1.
http://www.postgresql.org/docs/8.1/static/release-8-1.html
See section E.4.3.9 - they were defined in 8.1
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend