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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Richard Huxton <dev(at)archonet(dot)com>, abief_ag_-postgresql(at)yahoo(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: transactions in functions, possible bug or what I'm doing
Date: 2004-11-19 17:08:50
Message-ID: 29318.1100884130@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> On Fri, Nov 19, 2004 at 12:59:07PM +0000, 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 wrong:

You can't use explicit savepoint commands, but the exception syntax does
essentially the same thing implicitly.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Don Drake 2004-11-19 17:12:38 NULLS and string concatenation
Previous Message Michael Fuhr 2004-11-19 16:23:09 Re: transactions in functions, possible bug or what I'm doing