Docs incorrectly claiming equivalence between show and pg_settings

Поиск
Список
Период
Сортировка
От Stefan Seifert
Тема Docs incorrectly claiming equivalence between show and pg_settings
Дата
Msg-id 6963016.0JgteVRq9S@sunshine.detonation.org
обсуждение исходный текст
Ответы Re: Docs incorrectly claiming equivalence between show and pg_settings  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
Hi!

http://www.postgresql.org/docs/devel/static/sql-show.html claims:
"Also, the pg_settings system view produces the same information."

This is not entirely correct. On IRC I was told, that the view only contains
settings set from C, not user defined settings defined by the SET command:

timemngt=# set my.test = 'test';
                                          
SET
                                          
timemngt=# show my.test;
                                          
┌─────────┐
                                          
│ my.test │
                                          
├─────────┤
                                          
│ test    │
                                          
└─────────┘
                                          
(1 row)
                                          

timemngt=# select * from pg_settings where name = 'my.test';
                                          
timemngt=#

Including this rather obscure bit of information might help another user down
the road.

Thanks,
Stefan Seifert


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: misleading lang_name case in CREATE FUNCTION doc.
Следующее
От: "Pavel Holec"
Дата:
Сообщение: pg_dump hangs