Re: Problems with unconstrained join

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with unconstrained join
Date: 2002-03-06 17:06:43
Message-ID: 23360.1015434403@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oliver Elphick <olly(at)lfix(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Eduardo Gomez Noguera 2002-03-06 17:29:28 Re: joins?
Previous Message Gregory Wood 2002-03-06 16:57:57 Re: joins?