Re: DBD::Pg/perl question, kind of...

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: DBD::Pg/perl question, kind of...
Дата
Msg-id 877itmljqb.fsf@suzuka.mcnaught.org
обсуждение исходный текст
Ответ на Re: DBD::Pg/perl question, kind of...  ("Albe Laurenz" <all@adv.magwien.gv.at>)
Ответы Re: DBD::Pg/perl question, kind of...  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
"Albe Laurenz" <all@adv.magwien.gv.at> writes:

> So there is no automatic way of handling it.
>
> You will probably have to consider it in your code and use
> SELECT-Statements
> with a LIMIT clause.

Either that, or explicitly DECLARE a CURSOR and use FETCH from that
cursor in batches.  You can do this in Perl even though the automatic
cursor support is not yet there.  You are restricted to staying in a
transaction while the cursor is open, so if you want to work outside
of transactions LIMIT/OFFSET is your only way.

-Doug

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

Предыдущее
От: Denis Gasparin
Дата:
Сообщение: Getting Text data as C string
Следующее
От: Stefan Berglund
Дата:
Сообщение: Is This A Set Based Solution?