> <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.
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.
Thanks a lot,
Ying
> <snip>