back-end dies on select
prodex=# select category_id, category_name from category natural join category_product natural join product;
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.
!#
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?
--
Matt Beauregard
Information Technology Operations, DesignScape
Ph: +61 2 9361 4233 Fx: +61 2 9361 4633
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