On Mon, Oct 17, 2005 at 12:50:29PM +0100, Yogaraj. C wrote:
> When I was executing the procedure (with Transaction), postgres will
> producing the following error.
> ERROR: SPI_prepare() failed on "START TRANSACTION"
> CONTEXT: PL/pgSQL function "sp_example1" line 4 at SQL statement
"Functions and trigger procedures are always executed within a
transaction established by an outer query --- they cannot start or
> If anyone know the solution for this, pleas help me.
What problem are you trying to solve? PostgreSQL 8.0 introduced
savepoints, which you can use in PL/pgSQL via an EXCEPTION clause:
Another possibility might be to use dblink to make another connection
to the database from within the function and execute transactions
over that connection.
In response to
pgsql-bugs by date
|Next:||From: Alvaro Herrera||Date: 2005-10-18 14:32:55|
|Subject: Re: BUG #1971: Start Transaction is giving Errors !!!|
|Previous:||From: Richard Huxton||Date: 2005-10-18 13:15:53|
|Subject: Re: BUG #1972: index error with space character|