From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: CTTAS w/ DISTINCT ON crashes backend |
Date: | 2004-01-22 00:29:16 |
Message-ID: | 2271.1074731356@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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 probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
I'm getting an Assert failure, which no doubt detects the problem much
sooner than you were doing. The problem is in adding OIDs to rows that
initially did not have 'em when returned from the SELECT DISTINCT plan.
So your best immediate workaround is to create the first temp table with
oids, or create the second one without.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2004-01-22 01:02:13 | Re: CTTAS w/ DISTINCT ON crashes backend |
Previous Message | Alvaro Herrera | 2004-01-22 00:12:56 | Re: postgresql + apache under heavy load |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2004-01-22 01:02:13 | Re: CTTAS w/ DISTINCT ON crashes backend |
Previous Message | Tom Lane | 2004-01-21 23:51:56 | Re: CTTAS w/ DISTINCT ON crashes backend |