Re: BUG #5669: server process was terminated by exception 0xC0000005

On Wed, Sep 22, 2010 at 1:54 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>> Excerpts from Tom Lane's message of mié sep 22 13:36:18 -0400 2010:
>>> Well, the more general point is what should "SHOW session_authorization"
>>> show in an autovacuum process?  The fact that Andrew wasn't
>>> intentionally doing that doesn't mean that someone else might not try
>>> it.  I 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.  The latter seems like more work than it's worth though.
>
>> +1 for the illegal value.
>
> OK.  I 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?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company