Re: Postgresql 7.3.2 Crash - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgresql 7.3.2 Crash
Date
Msg-id 11670.1048778521@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql 7.3.2 Crash  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Postgresql 7.3.2 Crash
List pgsql-bugs
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> That's because the set default uses a pretty ugly hack.  It plans the
> query with =NULL and then replaces the NULL with the default value's
> stored plan info.  My first guess is that it's something with this that's
> causing the crash.

Yeah, it's failing to allow for the possible need to insert a type
coercion step.  This code shouldn't be here at all, really --- it should
be using build_column_default instead of messing about with the
default expression directly.  I can fix it, unless you want to...

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #922: PANIC: open of /scratch/production_2/pg_clog/0996 failed: No such file or directory
Next
From: Stephan Szabo
Date:
Subject: Re: Postgresql 7.3.2 Crash