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
|
Список | 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 по дате отправления: