> 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