Re: [HACKERS] MVCC works in serialized mode!
Vadim Mikheev <vadim@krs.ru>
From: Vadim Mikheev <vadim@krs.ru>
To: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Cc: hackers@postgreSQL.org
Date: 1999-01-10T17:12:13Z
Lists: 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