Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

pgsql: Make pg_relation_size() and friends return NULL if the object do


  • From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
  • To: pgsql-committers(at)postgresql(dot)org
  • Subject: pgsql: Make pg_relation_size() and friends return NULL if the object do
  • Date: Thu, 19 Jan 2012 11:18:12 +0000
  • Message-id: <E1Rnq0S-0002zi-R3@gemulon.postgresql.org> <text/plain>

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

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/fa352d662e57fa150158b9cb0a8f127250f8c97f

Modified Files
--------------
doc/src/sgml/func.sgml         |    5 ++
src/backend/utils/adt/dbsize.c |  119 ++++++++++++++++++++++++++++------------
2 files changed, 89 insertions(+), 35 deletions(-)



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group