SHOW ALL doesn't actually SHOW ALL

From: David Fetter <david(at)fetter(dot)org>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: SHOW ALL doesn't actually SHOW ALL
Date: 2008-08-20 17:45:19
Message-ID: 20080820174519.GK7447@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

I've noticed that neither SHOW ALL nor SELECT ... FROM pg_settings
shows the value of custom GUCs, even though SHOW will do so for any
given one. For example:

SHOW plperl.use_strict;
plperl.use_strict
-------------------
true
(1 row)

SELECT * FROM pg_settings WHERE "name" = 'plperl.use_strict';
name | setting | unit | category | short_desc | extra_desc | context | vartype | source | min_val | max_val
------+---------+------+----------+------------+------------+---------+---------+--------+---------+---------
(0 rows)

Is this a bug?

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2008-08-20 17:53:57 Re: [HACKERS] [FINALLY] the TODO list has migrated to Wiki
Previous Message Magnus Hagander 2008-08-20 17:43:30 Re: [FINALLY] the TODO list has migrated to Wiki