Re: [HACKERS] CTTAS w/ DISTINCT ON crashes backend

2004-01-21 Thread Mike Mascari
Tom Lane wrote: The crash I'm getting can be boiled down to this: regression=# create table fooey(f1 int) without oids; CREATE TABLE regression=# insert into fooey values(11); INSERT 0 1 regression=# create temp table fooey2 as select distinct * from fooey; server closed the connection unexpected

Re: [HACKERS] CTTAS w/ DISTINCT ON crashes backend

2004-01-21 Thread Tom Lane
The crash I'm getting can be boiled down to this: regression=# create table fooey(f1 int) without oids; CREATE TABLE regression=# insert into fooey values(11); INSERT 0 1 regression=# create temp table fooey2 as select distinct * from fooey; server closed the connection unexpectedly This p