Received: from nimbus.dartmouth.edu (nimbus.dartmouth.edu [129.170.16.33]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA24354 for ; Thu, 1 Jun 2000 01:07:31 -0400 (EDT) (envelope-from iliev@nimbus.dartmouth.edu) Received: (from iliev@localhost) by nimbus.dartmouth.edu (8.9.3/8.9.3) id BAA22920; Thu, 1 Jun 2000 01:07:27 -0400 From: "Alexander H. Iliev" Message-Id: <200006010507.BAA22920@nimbus.dartmouth.edu> Subject: Re: question on diagnostics To: tgl@sss.pgh.pa.us (Tom Lane) Date: Thu, 1 Jun 2000 01:07:26 -0400 (EDT) Cc: pgsql-sql@postgresql.org In-Reply-To: <13146.959834231@sss.pgh.pa.us> from "Tom Lane" at Jun 01, 2000 12:37:11 AM X-Mailer: ELM [version 2.5 PL1] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/2 > > oh, btw this select refused to use an SQL natural join among the 3 > > relations - the server gives up and disconnects without warning. > > That sounds like a garden-variety bug. I'd be willing to look at it > if I had a complete example to follow, but I don't want to try to > reverse-engineer your table definitions... a join with 3 tables never seems to work: test=# create table a(a int); CREATE test=# create table b(a int); CREATE test=# create table c(a int); CREATE test=# insert into a values (1); INSERT 23734 1 test=# insert into b values (1); INSERT 23744 1 test=# insert into c values (1); INSERT 23736 1 test=# select * test-# from a, b, c test-# where a.a = b.a AND test-# b.a = c.a; a | a | a ---+---+--- 1 | 1 | 1 (1 row) test=# select * from a natural inner join b natural inner join c; pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. alex