Re: question on diagnostics

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Alexander H(dot) Iliev" <iliev(at)nimbus(dot)dartmouth(dot)edu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: question on diagnostics
Date: 2000-10-02 04:17:13
Message-ID: 200010020417.AAA17102@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I can confirm that this is now fixed, and will appear in 7.1 when it is
released.

test=> select * from a natural inner join b natural inner join c;
a
---
1
(1 row)

> > > 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
>
>

--
Bruce Momjian | http://candle.pha.pa.us
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Craig May 2000-10-02 04:56:20 currval
Previous Message Philip Warner 2000-10-01 04:05:39 Re: how can I mirror a postgres database