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

From Bruce Momjian
Subject Re: [SQL] Backend crash
Date
Msg-id 200001241717.MAA20648@candle.pha.pa.us
Whole thread Raw
In response to Backend crash  (Mark Volpe <volpe.mark@epamail.epa.gov>)
List pgsql-sql
> The following sequence causes PostgreSQL to
> crash on my Linux box:
> 
> -- Any example table here will do
> 
> CREATE TABLE numbers ( value int );
> INSERT INTO numbers VALUES(1);
> INSERT INTO numbers VALUES(2);
> INSERT INTO numbers VALUES(3);
> INSERT INTO numbers VALUES(4);
> 
> -- Now the crash sequence
> 
> BEGIN;
> SELECT * INTO TEMP numbers2 FROM numbers;
> SELECT * FROM numbers2;
> 
> -- Bang!!! --
> 
> Can anybody reproduce this?

Fixed in current source tree.  We had some problems with temp tables
created inside transactions.  Next release will fix this.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Backend crash
Next
From: Mark Volpe
Date:
Subject: Re: [SQL] Backend crash