Re: [GENERAL] Savepoints in PL/pgSQL

2006-12-20 Thread BigSmoke
On Dec 19, 7:03 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote: > On 19 Dec 2006 08:37:01 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote: > > > What would solve my problem is if there was a > > method to, at the end of a begin/end block, > > rollback the changes made in that block > > without having to ra

Re: [GENERAL] Savepoints in PL/pgSQL

2006-12-19 Thread Bernd Helmle
On 19 Dec 2006 08:37:01 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote: [...] What would solve my problem is if there was a > method to, at the end of >> a begin/end block, I could rollback the changes made in that block >> without having to raise an exception. Is it somehow possible to >> explici

Re: [GENERAL] Savepoints in PL/pgSQL

2006-12-19 Thread BigSmoke
On Dec 19, 5:32 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote: > On Dec 19, 5:00 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote: > > > > > On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote: > > > > On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote: > > > > > I understand that due to

Re: [GENERAL] Savepoints in PL/pgSQL

2006-12-19 Thread BigSmoke
On Dec 19, 5:00 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote: > On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote: > > > > > On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote: > > > > I understand that due to a lack of nested transaction support, it is > > > not possible to u

Re: [GENERAL] Savepoints in PL/pgSQL

2006-12-19 Thread BigSmoke
On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote: > On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote: > > > I understand that due to a lack of nested transaction support, it is > > not possible to use START TRANSACTION within a PL/PgSQL function. What > > I, however, do

Re: [GENERAL] Savepoints in PL/pgSQL

2006-12-19 Thread Bernd Helmle
On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote: > I understand that due to a lack of nested transaction support, it is > not possible to use START TRANSACTION within a PL/PgSQL function. What > I, however, do not understand is why I can't use SAVEPOINT either. I'm > writing