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
