Re: SetQuerySnapshot, once again - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: SetQuerySnapshot, once again
Date
Msg-id 3D0DAEFD.2AABCD25@tpf.co.jp
Whole thread Raw
In response to SetQuerySnapshot, once again  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SetQuerySnapshot, once again  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> I've been busy working on my presentation on concurrency for the
> upcoming O'Reilly conference.  While doing so, I've been thinking
> more about the question of when to do SetQuerySnapshot calls inside
> functions.  We've gone around on that before, without much of a
> consensus on what to do; see for example the thread starting at
> http://fts.postgresql.org/db/mw/msg.html?mid=1029236
> 
> I have now become convinced that it is correct, in fact necessary,
> to do SetQuerySnapshot for each new user-supplied query, whether
> it's inside a function or not.

I have a question. Could the functions which contain no 
queries other than SELECT be stable(returns the definite
result for a query) with it ? 

regards,
Hiroshi Inouehttp://w2422.nsk.ne.jp/~inoue/


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Native OLE DB. What do you think about it
Next
From: Vince Vielhaber
Date:
Subject: Re: WITH handling in CREATE USER, etc