Re: transactions in multiple action rules

On Mon, Dec 20, 2004 at 23:15:39 -0500,
Ron Peterson <rpeterso(at)mtholyoke(dot)edu> wrote:
> Do the multiple actions within a multiple action rule implicitly reside
> within a transaction? I notice that if I brace my multiple actions with
> BEGIN; and COMMIT;, that I get a syntax error, so I'm assuming that's
> because they are superfluous in that context... ?
>
> (I want to be sure that I can count on 'currval' returning the sequence
> value returned by the previous action's 'nextval', so that I know I am
> inserting the proper foreign key into a table after inserting a record
> into the referenced table.)

currval returns the last value given out by nextval in the same session.
So you don't need to worry about conflicts between sessions.