Re: back-end dies on select - Mailing list pgsql-general

From Tom Lane
Subject Re: back-end dies on select
Date
Msg-id 1755.968305530@sss.pgh.pa.us
Whole thread Raw
In response to back-end dies on select  (Matt Beauregard <matt@designscape.com.au>)
List pgsql-general
Matt Beauregard <matt@designscape.com.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

pgsql-general by date:

Previous
From: Matt Beauregard
Date:
Subject: back-end dies on select
Next
From: Mark Kirkwood
Date:
Subject: RE:Error building JDBC Driver