pgsql: Remove spclocation field from pg_tablespace

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Remove spclocation field from pg_tablespace
Date: 2011-12-07 09:37:50
Message-ID: E1RYDwk-00022P-Ev@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Remove spclocation field from pg_tablespace

Instead, add a function pg_tablespace_location(oid) used to return
the same information, and do this by reading the symbolic link.

Doing it this way makes it possible to relocate a tablespace when the
database is down by simply changing the symbolic link.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/16d8e594acd96661267cb7897834f9cba51a2ffd

Modified Files
--------------
contrib/pg_upgrade/info.c | 25 +++++++++++++++-------
contrib/pg_upgrade/tablespace.c | 18 ++++++++++-----
doc/src/sgml/catalogs.sgml | 7 ------
doc/src/sgml/func.sgml | 9 ++++++++
doc/src/sgml/xaggr.sgml | 4 +-
src/backend/commands/tablespace.c | 2 -
src/backend/utils/adt/misc.c | 39 +++++++++++++++++++++++++++++++++++
src/bin/pg_dump/pg_dumpall.c | 11 +++++++++-
src/bin/psql/describe.c | 23 ++++++++++++++------
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 3 ++
src/include/catalog/pg_tablespace.h | 12 ++++------
src/include/utils/builtins.h | 1 +
13 files changed, 115 insertions(+), 41 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jan Urbański 2011-12-07 10:16:54 Re: [COMMITTERS] pgsql: plpython: Add SPI cursor support
Previous Message Tom Lane 2011-12-07 05:19:51 pgsql: Create a "sort support" interface API for faster sorting.