| From: | Dmitry Karasik <dmitry(at)karasik(dot)eu(dot)org> |
|---|---|
| To: | Dmitry Karasik <dmitry(at)karasik(dot)eu(dot)org> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: prepared queries in plperl |
| Date: | 2005-10-06 10:28:25 |
| Message-ID: | 84psqjgcs6.fsf@tetsuo.karasik.eu.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Dmitry!
On 27 Sep 05 at 16:16, "Dmitry" (Dmitry Karasik) wrote to "Andrew Dunstan":
Andrew> Meanwhile, I will observe that this very desirable feature needs
Andrew> an interface with spi_fetchrow()
I re-worked the patch ( http://www.karasik.eu.org/misc/plperl.diff ) and
now there's also spi_query_prepared(), that returns a cursor for a
previously prepared query that is to be used with subsequent spi_fetchrow()
calls.
I also modified spi_fetchrow() itself to avoid a couple of memory leaks,
and added spi_cursor_close() for cases where not all rows are fetched.
--
Sincerely,
Dmitry Karasik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2005-10-06 10:37:36 | Re: [PERFORM] A Better External Sort? |
| Previous Message | Michael Stone | 2005-10-06 09:49:34 | Re: [HACKERS] A Better External Sort? |