On Wed, Sep 22, 2010 at 1:54 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> Excerpts from Tom Lane's message of mi=E9 sep 22 13:36:18 -0400 2010:
>>> Well, the more general point is what should "SHOW session_authorization"
>>> show in an autovacuum process? =A0The fact that Andrew wasn't
>>> intentionally doing that doesn't mean that someone else might not try
>>> it. =A0I think we can either decide it should be an obviously-illegal
>>> value, or try to make it return the name of the cluster-creating
>>> superuser. =A0The latter seems like more work than it's worth though.
>
>> +1 for the illegal value.
>
> OK. =A0I just dug through all the other show-hook functions and confirmed
> that show_session_authorization is the only one that will dump core if
> its variable is NULL, so it looks like we have just one case to fix.
> Will get on it once I get my repo back together ...
Can SHOW return a NULL value, rather than the empty string?
--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company