diff options
author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2012-01-19 13:06:30 +0200 |
---|---|---|
committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2012-01-19 13:06:30 +0200 |
commit | fa352d662e57fa150158b9cb0a8f127250f8c97f (patch) | |
tree | 5a636ce02b86bd501db3dc8d7cf7901bd8058d4d /doc/src | |
parent | 6f6b46c9c0ca3d96acbebc5499c32ee6369e1eec (diff) | |
download | postgresql-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.sgml | 5 |
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> |