Add GET STACKED DIAGNOSTICS plpgsql command to retrieve exception info. This is more SQL-spec-compliant, more easily extensible, and better performing than the old method of inventing special variables.
Pavel Stehule, reviewed by Shigeru Hanada and David Wheeler Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/3d4890c0c5d27dfdf7d1a8816d7bdcdba3c39d21 Modified Files -------------- doc/src/sgml/plpgsql.sgml | 121 +++++++++++++++++++++++++++++---- src/backend/utils/errcodes.txt | 55 +++++++++------- src/pl/plpgsql/src/gram.y | 89 +++++++++++++++++++++++- src/pl/plpgsql/src/pl_exec.c | 71 ++++++++++++++++++-- src/pl/plpgsql/src/pl_funcs.c | 47 ++++++++----- src/pl/plpgsql/src/pl_scanner.c | 7 ++ src/pl/plpgsql/src/plpgsql.h | 11 +++- src/test/regress/expected/plpgsql.out | 75 ++++++++++++++++++++ src/test/regress/sql/plpgsql.sql | 70 +++++++++++++++++++ 9 files changed, 480 insertions(+), 66 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers