Re: [HACKERS] MVCC works in serialized mode! - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] MVCC works in serialized mode!
Date
Msg-id 3698DF6D.542113C2@krs.ru
Whole thread Raw
In response to Re: [HACKERS] MVCC works in serialized mode!  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
"Thomas G. Lockhart" wrote:
> 
> > > No comments on this?
> > > I would like to make BEGIN implicit...
> > > Objections?
> > Informix requires BEGIN.  Ingres does not, but has 'set autocommit'
> > mode, so each SQL statement is its own transaction, like we have now.
> 
> imho we should have an Ingres-like feature for "autocommit". We can have
> the default be "set autocommit on" (probably with an equals sign like
> our other "set" variables) and we can have it be a run-time option like
> DATESTYLE and other settable parameters. So you can configure your
> server or your client environment to always behave the way you prefer.
> 
> I'd be happy to implement the syntax and the environment variable parts;
> just need a global boolean value to check and set...

Nice! TIA -:)

Could you also change configure stuff, to choose default mode
before compiling?

Vadim


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] max backends checking patch
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: TCL/TK configure problems