| From: | Network Administrator <netadmin(at)vcsn(dot)com> |
|---|---|
| To: | postgres general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Interfaces that support cursors |
| Date: | 2003-10-10 16:43:04 |
| Message-ID: | 1065804184.3f86e198488ea@webmail.vcsn.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've got a Pg 7.1.3 release that I'm going to upgrade to 7.4 but in the meantime
I wanted to know if Pg.pm (or DBD:Pg) supported using cursors. I would guess
that they they don't because from what I understand every executed query in this
interface is implicitly wrapped in a transaction (thus there is an implicit
commit that would close the cursor).
I suppose I could use the fetchrow method (since the result set is not that big)
but in general, how should/could one handle implements cursors with this
interface. Thanks to all in advance...
--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-10-10 16:47:47 | Re: Table partitioning for maximum speed? |
| Previous Message | greg | 2003-10-10 16:30:20 | Re: Table partitioning for maximum speed? |