July 20th, 2011 by depesz | Tags: context, detail, error, exception, hint, pg92, plpgsql, postgresql, raise, stack trace | 1 comment »
On 18th of July, Tom Lane committed patch: 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 ...
CONTEXT messages are quite informative, but when you don't need them, they can be real pain in the eyes: psql:trees.sql:68: NOTICE: Adding tree structures to table public.testit. CONTEXT: SQL function "add_tree_structure" statement 1 psql:trees.sql:68: NOTICE: Tree table will be public.testit_tree. CONTEXT: ...
