Re: Should we SetQuerySnapshot() between actions of a rule?

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.
> But perhaps we had better stick to our historical behavior.
> pg_exec_query_string has done a SetQuerySnapshot per query for a long
> time, and I can't recall anyone ever complaining about it.

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

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110