Re: cursors outside transactions
От | Hiroshi Inoue |
---|---|
Тема | Re: cursors outside transactions |
Дата | |
Msg-id | 3E77B318.C8EFB27F@tpf.co.jp обсуждение исходный текст |
Ответ на | Re: cursors outside transactions (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: cursors outside transactions
Re: cursors outside transactions Re: cursors outside transactions |
Список | pgsql-hackers |
Bruce Momjian wrote: > > Tom Lane wrote: > > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > > The question here is do we want to offer a half-baked solution, > > recognizing that it's some improvement over no solution at all? > > Or do we feel it doesn't meet our standards? > > My question is how would you do this if you need this > functionality and you don't have WITH HOLD cursors? ODBC(maybe JDBC also) has cross-transaction result sets (rather than cursors) since long by simply holding all results for a query at client side. Why are cursors outside transactions expected eagerly ? Because it's very hard (almost impossible) for clients to provide a functionality to edit(display/scroll/updateetc) large result sets effectively. I don't object to a half-baked solution if there's a prospect of a real solution. However, I've never seen it and I have little time to investigate it unfortunately. regards, Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/
В списке pgsql-hackers по дате отправления: