Re: [SQL] transactions in functions, possible bug or what I'm doing

2004-11-19 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Fri, Nov 19, 2004 at 12:59:07PM +, Richard Huxton wrote: >> You can have what are called "savepoints" in version 8.0 though, which >> lets you trap errors and rollback to a named (saved) point in your function. > Savepoints in functions don't work

Re: [SQL] transactions in functions, possible bug or what I'm doing

2004-11-19 Thread Michael Fuhr
On Fri, Nov 19, 2004 at 12:59:07PM +, Richard Huxton wrote: > You can have what are called "savepoints" in version 8.0 though, which > lets you trap errors and rollback to a named (saved) point in your function. Savepoints in functions don't work as of 8.0.0beta4, unless I'm doing something

Re: [SQL] transactions in functions, possible bug or what I'm doing

2004-11-19 Thread Richard Huxton
Riccardo G. Facchini wrote: Why does select test_without_transaction(); return this info: "ABCD" (as should be) and select test_with_transaction(); returns this error? ERROR: SPI_prepare() failed on "start transaction" CONTEXT: PL/pgSQL function "test_with_transaction" line 6 at SQL statement I'v