Interfaces that support cursors

Поиск
Список
Период
Сортировка
От Network Administrator
Тема Interfaces that support cursors
Дата
Msg-id 1065804184.3f86e198488ea@webmail.vcsn.com
обсуждение исходный текст
Список 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

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Table partitioning for maximum speed?
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Interfaces that support cursors