Re: DBD::Pg/perl question, kind of... - Mailing list pgsql-general

From Douglas McNaught
Subject Re: DBD::Pg/perl question, kind of...
Date
Msg-id 877itmljqb.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Re: DBD::Pg/perl question, kind of...  ("Albe Laurenz" <all@adv.magwien.gv.at>)
Responses Re: DBD::Pg/perl question, kind of...  (Michael Fuhr <mike@fuhr.org>)
List 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 by date:

Previous
From: Denis Gasparin
Date:
Subject: Getting Text data as C string
Next
From: Stefan Berglund
Date:
Subject: Is This A Set Based Solution?