diff options
| author | Magnus Hagander <magnus@hagander.net> | 2011-12-07 10:35:00 +0100 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2011-12-07 10:37:33 +0100 |
| commit | 16d8e594acd96661267cb7897834f9cba51a2ffd (patch) | |
| tree | 4ab54a17950270328b54550af91aae4e2c6e245f /doc/src | |
| parent | c6e3ac11b60ac4a8942ab964252d51c1c0bd8845 (diff) | |
| download | postgresql-16d8e594acd96661267cb7897834f9cba51a2ffd.tar.gz postgresql-16d8e594acd96661267cb7897834f9cba51a2ffd.zip | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 7 | ||||
| -rw-r--r-- | doc/src/sgml/func.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/xaggr.sgml | 4 |
3 files changed, 11 insertions, 9 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 8156c35916a..b8cc16f72a9 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -5392,13 +5392,6 @@ </row> <row> - <entry><structfield>spclocation</structfield></entry> - <entry><type>text</type></entry> - <entry></entry> - <entry>Location (directory path) of the tablespace</entry> - </row> - - <row> <entry><structfield>spcacl</structfield></entry> <entry><type>aclitem[]</type></entry> <entry></entry> diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index ddfb29a4338..e7f7fe0e889 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -13612,6 +13612,10 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); </indexterm> <indexterm> + <primary>pg_tablespace_location</primary> + </indexterm> + + <indexterm> <primary>pg_typeof</primary> </indexterm> @@ -13759,6 +13763,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); <entry>get the set of database OIDs that have objects in the tablespace</entry> </row> <row> + <entry><literal><function>pg_tablespace_location(<parameter>tablespace_oid</parameter>)</function></literal></entry> + <entry><type>text</type></entry> + <entry>get the path in the filesystem that this tablespace is located in</entry> + </row> + <row> <entry><literal><function>pg_typeof(<parameter>any</parameter>)</function></literal></entry> <entry><type>regtype</type></entry> <entry>get the data type of any value</entry> diff --git a/doc/src/sgml/xaggr.sgml b/doc/src/sgml/xaggr.sgml index 811934bd75b..1822f6d4abd 100644 --- a/doc/src/sgml/xaggr.sgml +++ b/doc/src/sgml/xaggr.sgml @@ -154,7 +154,7 @@ SELECT attrelid::regclass, array_accum(attname) attrelid | array_accum ---------------+--------------------------------------- - pg_tablespace | {spcname,spcowner,spclocation,spcacl} + pg_tablespace | {spcname,spcowner,spcacl,spcoptions} (1 row) SELECT attrelid::regclass, array_accum(atttypid::regtype) @@ -164,7 +164,7 @@ SELECT attrelid::regclass, array_accum(atttypid::regtype) attrelid | array_accum ---------------+--------------------------- - pg_tablespace | {name,oid,text,aclitem[]} + pg_tablespace | {name,oid,aclitem[],text[]} (1 row) </programlisting> </para> |