Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Backend crash

From: Mark Volpe <volpe(dot)mark(at)epamail(dot)epa(dot)gov>
To:
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Backend crash
Date: 2000-01-24 18:58:28
Message-ID: 388CA0D4.F54D9D8F@epamail.epa.gov (view raw or flat)
Thread:
Lists: pgsql-sql
Thanks, guys!

SELECT * INTO <good-old-unique-name-based-on-process-id> ...
works just fine for me :-)

Tom Lane wrote:
> 
> 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

pgsql-sql by date

Next:From: Bruce MomjianDate: 2000-01-24 19:08:13
Subject: Re: [SQL] Backend crash
Previous:From: Bruce MomjianDate: 2000-01-24 17:17:28
Subject: Re: [SQL] Backend crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group