Re: SetQuerySnapshot, once again

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: SetQuerySnapshot, once again
Дата
Msg-id 3D0DAEFD.2AABCD25@tpf.co.jp
обсуждение исходный текст
Ответ на SetQuerySnapshot, once again  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SetQuerySnapshot, once again  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Native OLE DB. What do you think about it
Следующее
От: Vince Vielhaber
Дата:
Сообщение: Re: WITH handling in CREATE USER, etc