From fa352d662e57fa150158b9cb0a8f127250f8c97f Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Thu, 19 Jan 2012 13:06:30 +0200 Subject: 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 --- doc/src/sgml/func.sgml | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 7d7aba7aeef..ff9b8b0853e 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -14979,6 +14979,11 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); the table name. + + If an OID that does not represent an existing object is passed as + argument to one of the above functions, NULL is returned. + + The functions shown in assist in identifying the specific disk files associated with database objects. -- cgit v1.2.3