Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5500: SPI_execute_plan_with_paramlist SPI_ERROR_TRANSACTION with savepoint - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5500: SPI_execute_plan_with_paramlist SPI_ERROR_TRANSACTION with savepoint
Date
Msg-id 13382.1276292113@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5500: SPI_execute_plan_with_paramlist SPI_ERROR_TRANSACTION with savepoint  ("Robert Walker" <robwalker01@speedymail.org>)
List pgsql-bugs
Tree view 
"Robert Walker" <robwalker01@speedymail.org> writes:
> SPI_execute_plan_with_paramlist seems to be newly introduced into 9.0 beta
> that is causing an error in pl/pgsql when attempting to create a savepoint.
> This did not happen when using version 8.4 (which I assume was not using
> SPI_execute_plan_with_paramlist), so I believe this is a regression.

Um, it's never been the case that you could execute a SAVEPOINT
statement inside plpgsql.  I'd be interested to see the case that
you claim worked in 8.4.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #5500: SPI_execute_plan_with_paramlist SPI_ERROR_TRANSACTION with savepoint