Re: [GENERAL] How to get transaction started always in WRITE mode.

2017-07-25 Thread rob stone
On Tue, 2017-07-25 at 11:32 +0200, Adam Šlachta wrote: > Hello, >   > In short: Is there any way how to setup PostgreSql 9.6 to always > start a transaction in WRITE mode? >   > Our related configuration: > "default_transaction_isolation" --> "read committed" > "default_transaction_read_only" -->

Re: [GENERAL] How to get transaction started always in WRITE mode.

2017-07-25 Thread Jerry Sievers
Adam Šlachta writes: > Hello Scott and other potential readers/writers, > > > >> Login to the database with psql as the same user that your java app > connects with try: > >> > >> show default_transaction_read_only; > >> This can be set per-user, it's possible you're getting tripped up > the

Re: [GENERAL] How to get transaction started always in WRITE mode.

2017-07-25 Thread Adam Šlachta
Hello Scott and other potential readers/writers, > Login to the database with psql as the same user that your java app connects > with try: > > show default_transaction_read_only; > This can be set per-user, it's possible you're getting tripped up there. show default_transaction_read_only;

Re: [GENERAL] How to get transaction started always in WRITE mode.

2017-07-25 Thread Scott Mead
On Tue, Jul 25, 2017 at 5:32 AM, Adam Šlachta wrote: > Hello, > > > > In short: Is there any way how to setup PostgreSql 9.6 to always start a > transaction in WRITE mode? > > > > Our related configuration: > > "default_transaction_isolation" --> "read committed" > > "default_transaction_read_onl

[GENERAL] How to get transaction started always in WRITE mode.

2017-07-25 Thread Adam Šlachta
Hello, In short: Is there any way how to setup PostgreSql 9.6 to always start a transaction in WRITE mode? Our related configuration: "default_transaction_isolation" --> "read committed" "default_transaction_read_only" --> "off" Longer description (for those who are interested, since it is