Re: Bug(?) with cursors using aggregate functions.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug(?) with cursors using aggregate functions.
Дата
Msg-id 13647.1051588311@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bug(?) with cursors using aggregate functions.  (Benjamin Scherrey <scherrey@proteus-tech.com>)
Ответы Re: Bug(?) with cursors using aggregate functions.
dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"
Список pgsql-general
Benjamin Scherrey <scherrey@proteus-tech.com> writes:
> I've been developing a web-based selection browser using cursors and
> discovered a very frustrating little feature as I try to MOVE
> FORWARD/BACKWARD through my selection.

You can't run a nontrivial query plan (anything more than a seqscan or
indexscan) backwards with any reliability.  There are fixes for this in
CVS tip, but not in any released version :-(.  It should also be noted
that the fix consists of saving-aside copies of all rows emitted by the
underlying query, so if you are talking about a large result set you
might not like the performance...

            regards, tom lane


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Bad timestamp external representation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bad timestamp external representation