From: | Stefan Seifert <nine(at)detonation(dot)org> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Docs incorrectly claiming equivalence between show and pg_settings |
Date: | 2014-02-12 14:54:31 |
Message-ID: | 6963016.0JgteVRq9S@sunshine.detonation.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2014-02-12 21:46:44 | Re: [DOCS] Viability of text HISTORY/INSTALL/regression README files (was Re: [COMMITTERS] pgsql: Document a few more regression test hazards.) |
Previous Message | Dave Page | 2014-02-12 12:01:29 | Re: Ways to improve PgAdmin III SQL context help |
From | Date | Subject | |
---|---|---|---|
Next Message | Kohei KaiGai | 2014-02-12 15:42:29 | Re: contrib/cache_scan (Re: What's needed for cache-only table scan?) |
Previous Message | Bruce Momjian | 2014-02-12 14:49:18 | Re: Performance Improvement by reducing WAL for Update Operation |