From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Matt Beauregard <matt(at)designscape(dot)com(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: back-end dies on select |
Date: | 2000-09-07 05:45:30 |
Message-ID: | 1755.968305530@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Matt Beauregard <matt(at)designscape(dot)com(dot)au> writes:
> prodex=# select category_id, category_name from category natural join category_product natural join product;
> pqReadData() -- backend closed the channel unexpectedly.
> That's the first time anything like this has happened... no doubt I
> have the join syntax wrong (I don't normally use natural joins) but it
> shouldn't bring down my connection, should it?
Nope, it shouldn't :-(. This is a known bug in 7.0.* --- "JOIN" syntax
doesn't work for more than two tables joined together. It'll be fixed
for 7.1.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2000-09-07 08:25:34 | RE:Error building JDBC Driver |
Previous Message | Matt Beauregard | 2000-09-07 05:38:11 | back-end dies on select |