March 7th, 2013 by depesz | Tags: , , , , , , | Comments Off on Waiting for 9.3 – Provide database object names as separate fields in error messages.

Yet another missed thing for "Waiting for 9.3". Sorry about that. On 29th of January, Tom Lane committed patch: Provide database object names as separate fields in error messages. This patch addresses the problem that applications currently have to extract object names from possibly-localized ...

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: ...