Re: BUG #4835: psql server crashes when using non-existing functions

David Sommerseth wrote:
> The following bug has been logged online:
>
> Bug reference:      4835
> Logged by:          David Sommerseth
> Email address:      dazo@users.sourceforge.net
> PostgreSQL version: 8.3.7
> Operating system:   Linux (Gentoo Hardened 2008 / x86 - 32bit)
> Description:        psql server crashes when using non-existing functions
> Details:
>
> (This might be a duplicate of a mail I tried to send directly to the mailing
> list, sorry if it gets dupped.  I didn't find my report in the archives.
> This new entry, via the web form, got more information as well)
>
> I discovered this issue when upgrading from 8.3.5 to 8.3.7
>
> ...
 >
> I degraded to 8.3.5 again, and this behaviour disappeared.
>
> The behaviour is sometimes better when the non-existing function do not
> start with 'pg_', as it seems to recover better.  But not always.

Can you get a core dump, and post the gdb backtrace?

ulimit -c unlimited
pg_ctl start
< do the test to cause segfault>
gdb $PGDATA/core
bt

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com