January 22nd, 2012 by depesz | Tags: exception, pg92, pg_relation_size, pg_stat_user_functions, pg_table_size, pg_total_relation_size, plpgsql, postgresql | No comments »
On 19t of January, Heikki Linnakangas committed patch: Make pg_relation_size() and friends return NULL if the object doesn't exist. That avoids errors when the functions are used in queries like "SELECT pg_relation_size(oid) FROM pg_class", and a table is dropped concurrently. Phil Sorber
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 ...
