On Mon, Jun 13, 2005 at 07:39:40PM +0530, Abhijit Menon-Sen wrote: > 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?
I have some :) If we figure this out for PL/Perl, the general method will be applicable to PL/YourFavoriteLanguage, so even if you're not a fan of Perl, it's worth looking into. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
