Re: Connection.setReadOnly()

Поиск
Список
Период
Сортировка
Искать
От
Kris Jurka
Тема
Re: Connection.setReadOnly()
Дата
Msg-id
alpine.BSO.2.00.0912101744080.30821@leary.csoft.net
Ответ на
Connection.setReadOnly() (John R Pierce)
Список
Дерево обсуждения
Connection.setReadOnly() John R Pierce <pierce@hogranch.com>
Re: Connection.setReadOnly() Kris Jurka <books@ejurka.com>
Re: Connection.setReadOnly() John R Pierce <pierce@hogranch.com>
Re: Connection.setReadOnly() Oliver Jowett <oliver@opencloud.com>
Re: Connection.setReadOnly() John R Pierce <pierce@hogranch.com>
Re: Connection.setReadOnly() Greg Stark <gsstark@mit.edu>
Re: Connection.setReadOnly() "Albe Laurenz" <laurenz.albe@wien.gv.at>
Re: Connection.setReadOnly() Oliver Jowett <oliver@opencloud.com>
Re: Connection.setReadOnly() Craig Ringer <craig@postnewspapers.com.au>
Re: Connection.setReadOnly() Tom Lane <tgl@sss.pgh.pa.us>
Re: Connection.setReadOnly() John R Pierce <pierce@hogranch.com>
Re: Connection.setReadOnly() Tom Lane <tgl@sss.pgh.pa.us>
Re: Connection.setReadOnly() Oliver Jowett <oliver@opencloud.com>
Re: Connection.setReadOnly() John R Pierce <pierce@hogranch.com>
Re: Connection.setReadOnly() Kris Jurka <books@ejurka.com>
Re: Connection.setReadOnly() John R Pierce <pierce@hogranch.com>
Re: Connection.setReadOnly() Oliver Jowett <oliver@opencloud.com>


On Thu, 10 Dec 2009, John R Pierce wrote:

> does Connection.setReadOnly(true) block pgjdbc from automatically issuing 
> BEGIN;, similar to setAutoCommit(true) ?

No.

> if not, why not?
>

Just because your connection is readonly doesn't mean that everyone elses 
is as well.  If you want a consistent view of the database you can get 
that with a serializable transaction.

Kris Jurka
В списке pgsql-jdbc по дате отправления
От: John R Pierce
Дата:
Сообщение: Connection.setReadOnly()
От: John R Pierce
Дата:
Сообщение: Re: Connection.setReadOnly()
FAQ