pgsql: Make psql's \d+ show reloptions for all relkinds.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Make psql's \d+ show reloptions for all relkinds.
Дата
Msg-id E1T8YWB-0003PX-72@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Make psql's \d+ show reloptions for all relkinds.

Formerly it would only show them for relkinds 'r' and 'f' (plain tables
and foreign tables).  However, as of 9.2, views can also have reloptions,
namely security_barrier.  The relkind restriction seems pointless and
not at all future-proof, so just print reloptions whenever there are any.

In passing, make some cosmetic improvements to the code that pulls the
"tableinfo" fields out of the PGresult.

Noted and patched by Dean Rasheed, with adjustment for all relkinds by me.

Branch
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/b681a874d97a16693c59228660f8d8a75f723bf3

Modified Files
--------------
src/bin/psql/describe.c |   37 ++++++++++++++++++-------------------
1 files changed, 18 insertions(+), 19 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Make psql's \d+ show reloptions for all relkinds.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix pg_upgrade to cope with non-default unix_socket_directory sc