Re: Problems with unconstrained join

Oliver Elphick <olly@lfix.co.uk> writes:
> [ Cartesian product = 30,052,324 rows ]

> bray=# select p.id from product as p, stock;
> server sent data ("D" message) without prior row description ("T" message)
> server sent data ("D" message) without prior row description ("T" message)

libpq does not respond very gracefully to running out of memory for a
query result.  It doesn't crash exactly, but it loses track of what's
coming in, after which you get all these useless error messages.  Feel
free to fix it ...

            regards, tom lane