Re: Problems with unconstrained join

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with unconstrained join
Дата
Msg-id 23360.1015434403@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problems with unconstrained join  (Oliver Elphick <olly@lfix.co.uk>)
Ответы Re: Problems with unconstrained join  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: David Griffiths
Дата:
Сообщение: Re: Problems with unconstrained join
Следующее
От: "Gregory Wood"
Дата:
Сообщение: Re: joins?