Remove spclocation field from pg_tablespace
Magnus Hagander <magnus@hagander.net>
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.
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pg_upgrade/info.c | modified | +17 −8 |
| contrib/pg_upgrade/tablespace.c | modified | +12 −6 |
| doc/src/sgml/catalogs.sgml | modified | +0 −7 |
| doc/src/sgml/func.sgml | modified | +9 −0 |
| doc/src/sgml/xaggr.sgml | modified | +2 −2 |
| src/backend/commands/tablespace.c | modified | +0 −2 |
| src/backend/utils/adt/misc.c | modified | +39 −0 |
| src/bin/pg_dump/pg_dumpall.c | modified | +10 −1 |
| src/bin/psql/describe.c | modified | +16 −7 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +3 −0 |
| src/include/catalog/pg_tablespace.h | modified | +5 −7 |
| src/include/utils/builtins.h | modified | +1 −0 |