Postgres Pro
Downloads
Home   >   mailing lists

Re: Recovering from an exception - Mailing list pgsql-general

From Marko Tiikkaja
Subject Re: Recovering from an exception
Date
Msg-id op.wp9e77u4ye4vw9@blue.lan
Whole thread Raw
In response to Re: Recovering from an exception  ("Marko Tiikkaja" <pgmail@joh.to>)
List pgsql-general
Tree view 
On Wed, 02 Jan 2013 01:16:11 +0100, I wrote:
> I'm puzzled as to why AtEOSubXact_SPI() needs to unconditionally clear
> the surround SPI context, or why it assumes it's a good idea.

I managed to fix this by creating my own SPI context outside the
subtransaction for AtEOSubXact_SPI() to destroy, and everything appears to
be working correctly.


Regards,
Marko Tiikkaja

pgsql-general by date:

Previous
From: "Marko Tiikkaja"
Date:
Subject: Re: Recovering from an exception
Next
From: Ali Pouya
Date:
Subject: Using the NEW record in an EXECUTE command in a PL/pgSQL trigger function