diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-08-27 15:03:02 +0300 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-08-27 15:03:02 +0300 |
| commit | fd5b397ca4963bf91a54678be51207bf827e512a (patch) | |
| tree | aaca2392dc8944f8c4e78d48f56a428800ffe445 /doc/src | |
| parent | 3104cc89be65614ef3d0748e1cc19fb5394969e9 (diff) | |
| download | postgresql-fd5b397ca4963bf91a54678be51207bf827e512a.tar.gz postgresql-fd5b397ca4963bf91a54678be51207bf827e512a.zip | |
Implement the information schema with_hierarchy column
In PostgreSQL, this is included in the SELECT privilege, so show YES
or NO depending on whether SELECT is granted.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/information_schema.sgml | 18 |
1 files changed, 16 insertions, 2 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index 0f0cbfaa83a..8063d059c8d 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -3684,7 +3684,14 @@ ORDER BY c.ordinal_position; <row> <entry><literal>with_hierarchy</literal></entry> <entry><type>yes_or_no</type></entry> - <entry>Applies to a feature not available in <productname>PostgreSQL</></entry> + <entry> + In the SQL standard, <literal>WITH HIERARCHY OPTION</literal> + is a separate (sub-)privilege allowing certain operations on + table inheritance hierarchies. In PostgreSQL, this is included + in the <literal>SELECT</literal> privilege, so this column + shows <literal>YES</literal> if the privilege + is <literal>SELECT</literal>, else <literal>NO</literal>. + </entry> </row> </tbody> </tgroup> @@ -5364,7 +5371,14 @@ ORDER BY c.ordinal_position; <row> <entry><literal>with_hierarchy</literal></entry> <entry><type>yes_or_no</type></entry> - <entry>Applies to a feature not available in <productname>PostgreSQL</></entry> + <entry> + In the SQL standard, <literal>WITH HIERARCHY OPTION</literal> + is a separate (sub-)privilege allowing certain operations on + table inheritance hierarchies. In PostgreSQL, this is included + in the <literal>SELECT</literal> privilege, so this column + shows <literal>YES</literal> if the privilege + is <literal>SELECT</literal>, else <literal>NO</literal>. + </entry> </row> </tbody> </tgroup> |