Re: Are rules transaction safe? - Mailing list pgsql-general

From Oliver Fürst
Subject Re: Are rules transaction safe?
Date
Msg-id 43DA9FFB.20709@tsak.net
Whole thread Raw
In response to Re: Are rules transaction safe?  (Doug McNaught <doug@mcnaught.org>)
Responses Re: Are rules transaction safe?  (Doug McNaught <doug@mcnaught.org>)
Re: Are rules transaction safe?  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Hi Doug,

thanks for your answers so far. I think I should try to discuss that
matter in [pgsql-sql] instead.

On 27.01.2006 21:21, Doug McNaught wrote:
> Oliver Fürst <ofuerst@tsak.net> writes:
>
>>Basically I'm worried that the whole "relying on the last value of a
>>sequence" isn't such a great idea.
>
> 'currval()' is specifically written to Do The Right Thing.  See the
> docs.

My problem isn't answered in the manual, otherwise I wouldn't have
asked. I know that sequences are working correct for transactions
(either implicit or explicit).

But is nowhere stated if (multiple) commands inside a rule are treated
as an implicit transaction as a whole.

Regards,
Oliver

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Basic questions about PQprepare()
Next
From: Doug McNaught
Date:
Subject: Re: Are rules transaction safe?