At 2005-06-12 14:54:47 +0530, [EMAIL PROTECTED] wrote:
>
> The idea is to have spi_query call SPI_prepare/SPI_open_cursor, and have
> an spi_fetchrow that calls SPI_cursor_fetch. It works well enough, but I
> don't know how to reproduce spi_exec_query's error handling (it runs the
> SPI_execute in a subtransaction).
One possibility would be to make plperl_call_handler create the internal
subtransaction, so that all of the perl code runs inside it. But I'm not
sure if that would actually work, especially if one of the SPI functions
failed. But I can't think of what else to do, either.
Thoughts?
-- ams
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
