pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
isolation level and autocommit
3+ messages / 3 participants
[nested] [flat]

* isolation level and autocommit
@ 2005-04-20 08:12  Manfred Rebentisch <MRebentisch@comparat.de>
  0 siblings, 1 reply; 3+ messages in thread

From: Manfred Rebentisch @ 2005-04-20 08:12 UTC (permalink / raw)
  To: pgsql-admin

I have a question to configuration of PostgreSQL 7.3

If in var/lib/pgsql/data/postgresql.conf the variable autocommit is set to
true, I cannot work with transactions, because all is commited immediately.

I set autocommit to false and set default_transaction_isolation =
'serializable', because this I need for one application. In this
application I set the following command after connect:

SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE

Its work perfect.

But if I work with phpPgAdmin on the database, I have to use "BEGIN" and
"COMMIT" with every action. Is this changeable? It may be ok for me, if it
is only for the one database, but it is now for every pgsql-database on
this server.

I want to have 'autocommit=true' with the one database and the above
behaviour with the other database. How do I realize that?

Thank you for comments in advance.
 
Manfred Rebentisch




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: isolation level and autocommit
@ 2005-04-23 09:20  Peter Eisentraut <peter_e@gmx.net>
  parent: Manfred Rebentisch <MRebentisch@comparat.de>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2005-04-23 09:20 UTC (permalink / raw)
  To: Manfred Rebentisch <MRebentisch@comparat.de>; +Cc: pgsql-admin

Manfred Rebentisch wrote:
> I want to have 'autocommit=true' with the one database and the above
> behaviour with the other database. How do I realize that?

I suspect you could set it with ALTER DATABASE ... SET autocommit = 
true.

But the behavior of autocommit is really confusing and for that reason 
the option was removed in 7.4 so you may not want to bother learning 
its semantics.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: isolation level and autocommit
@ 2005-04-23 19:09  Manfred Rebentisch <mrebentisch@comparat.de>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Manfred Rebentisch @ 2005-04-23 19:09 UTC (permalink / raw)
  To: pgsql-admin

Am Samstag, 23. April 2005 11:20 schrieb Peter Eisentraut:
> Manfred Rebentisch wrote:
> > I want to have 'autocommit=true' with the one database and the above
> > behaviour with the other database. How do I realize that?
>
> I suspect you could set it with ALTER DATABASE ... SET autocommit =
> true.
>
> But the behavior of autocommit is really confusing and for that reason
> the option was removed in 7.4 so you may not want to bother learning
> its semantics.

Aah! Thank you for this information! I will have a look to 7.4 and come back, 
if I have more questions.

Bye
Manfred



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-04-23 19:09 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-20 08:12 isolation level and autocommit Manfred Rebentisch <MRebentisch@comparat.de>
2005-04-23 09:20 ` Peter Eisentraut <peter_e@gmx.net>
2005-04-23 19:09   ` Manfred Rebentisch <mrebentisch@comparat.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox