From: | Bruce Momjian <pgman(at)candle(dot)pha(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:17:28 |
Message-ID: | 200001241717.MAA20648@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Volpe | 2000-01-24 18:58:28 | Re: [SQL] Backend crash |
Previous Message | Tom Lane | 2000-01-24 17:16:56 | Re: [SQL] Backend crash |