Re: transactions in multiple action rules

Ron Peterson <rpeterso@mtholyoke.edu> writes:
> Do the multiple actions within a multiple action rule implicitly reside
> within a transaction?

Yes.  In the current code it is actually not possible for a single SQL
command issued by the client to give rise to more than one transaction.
(This might change if we invent some kind of stored-procedure engine, but
rules certainly can't do it.)

> (I want to be sure that I can count on 'currval' returning the sequence
> value returned by the previous action's 'nextval',

As Bruno pointed out, that really has nothing to do with how many
transactions are involved.  The per-session state that currval uses will
sit quietly for as long as you need.

            regards, tom lane