Perl y Cursores

From: Patricio Muñoz <adivisi(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Perl y Cursores
Date: 2007-10-03 21:35:22
Message-ID: b82041200710031435j6d6af81amf583592f9d2e3eed@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Estimados,
Alguien sabe si es posible utilizar cursores desde Perl utilizando dbi ?

Según la documentacion del modulo DBD:Pg, aparece una seccion dedicada a
cursores, la expongo

Cursors
<http://search.cpan.org/%7Edbdpg/DBD-Pg-1.49/Pg.pm#___top>

"Although PostgreSQL has a cursor concept, it has not been used in the
current implementation. Cursors in PostgreSQL can only be used inside a
transaction block. Because only one transaction block at a time is allowed,
this would have implied the restriction not to use any nested
SELECTstatements. Hence the
execute method fetches all data at once into data structures located in the
front-end application. This approach must to be considered when selecting
large amounts of data!"
Según lo que lei y entendi no es soportado ?

Saludos

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2007-10-03 21:37:41 Re: Sobre espejado de Bases de datos
Previous Message Teofilo Oviedo 2007-10-03 20:58:25 Sobre espejado de Bases de datos