Re: [SQL] Backend crash - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Backend crash
Date
Msg-id 25643.948734216@sss.pgh.pa.us
Whole thread Raw
In response to Backend crash  (Mark Volpe <volpe.mark@epamail.epa.gov>)
List pgsql-sql
Mark Volpe <volpe.mark@epamail.epa.gov> writes:
> BEGIN;
> SELECT * INTO TEMP numbers2 FROM numbers;
> SELECT * FROM numbers2;
> -- Bang!!! --
> Can anybody reproduce this?

Yah :-(.  There are several nasty bugs in 6.5.*'s support for TEMP
tables.  We believe they are all fixed for 7.0, but the changes are
intertwined with a lot of other stuff, and so back-patching the fixes
didn't look very practical.

The only good news is that 7.0 goes beta next week...
        regards, tom lane


pgsql-sql by date:

Previous
From: Mark Volpe
Date:
Subject: Backend crash
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] Backend crash