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
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 |