Re: Should we SetQuerySnapshot() between actions of a rule? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Should we SetQuerySnapshot() between actions of a rule?
Date
Msg-id 17343.1051810520@sss.pgh.pa.us
Whole thread Raw
In response to Re: Should we SetQuerySnapshot() between actions of a rule?  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: Should we SetQuerySnapshot() between actions of a rule?
List pgsql-hackers
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Thu, May 01, 2003 at 11:55:45AM -0400, Tom Lane wrote:
>> interactive execution.  But which one do we want?  I could see an
>> argument that it'd be best for all the actions of a rule to see a
>> consistent snapshot of the state of other transactions; and not doing
>> the extra SetQuerySnapshot() calls would save some cycles.

> Can't you get the consistent snapshot by running SERIALIZABLE anyway?

Yeah, but that may do more than you want (like force a rollback on
update conflicts...)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: select ... into question
Next
From: "Neil Conway"
Date:
Subject: Re: FOR EACH STATEMENT triggers