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

"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