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