aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>2012-01-19 13:06:30 +0200
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>2012-01-19 13:06:30 +0200
commitfa352d662e57fa150158b9cb0a8f127250f8c97f (patch)
tree5a636ce02b86bd501db3dc8d7cf7901bd8058d4d /doc/src
parent6f6b46c9c0ca3d96acbebc5499c32ee6369e1eec (diff)
downloadpostgresql-fa352d662e57fa150158b9cb0a8f127250f8c97f.tar.gz
postgresql-fa352d662e57fa150158b9cb0a8f127250f8c97f.zip
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
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/func.sgml5
1 files changed, 5 insertions, 0 deletions
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
@@ -14980,6 +14980,11 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup());
</para>
<para>
+ If an OID that does not represent an existing object is passed as
+ argument to one of the above functions, NULL is returned.
+ </para>
+
+ <para>
The functions shown in <xref linkend="functions-admin-dblocation"> assist
in identifying the specific disk files associated with database objects.
</para>