Re: [SQL] Backend crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Volpe <volpe(dot)mark(at)epamail(dot)epa(dot)gov>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Backend crash
Date: 2000-01-24 17:16:56
Message-ID: 25643.948734216@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mark Volpe <volpe(dot)mark(at)epamail(dot)epa(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2000-01-24 17:17:28 Re: [SQL] Backend crash
Previous Message Mark Volpe 2000-01-24 16:25:21 Backend crash