Обсуждение: SPI_exec() + PG_TRY/PG_CATCH

Guys,


So I haven't got my question answered, thus trying it again ;)

How do I handle SPI errors properly without rethrowing them or
using subtransactions ? My current code works (simple PG_CATCH()
with resseting of error state), but reports reference leaks for
every failed SPI_exec() call...

Thanks!


Best regards,
Alex Vinogradovs

"Aleksandrs Vinogradovs" <avinogradovs@Clearpathnet.com> writes:
> How do I handle SPI errors properly without rethrowing them or
> using subtransactions ?

Those are your only two choices.

> My current code works (simple PG_CATCH()
> with resseting of error state), but reports reference leaks for
> every failed SPI_exec() call...

The warnings are the least of your worries.  Without a subxact abort,
there is all sorts of state that has not been properly cleaned up.

            regards, tom lane