Re: [HACKERS] MVCC works in serialized mode!

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, Vadim Mikheev <vadim(at)krs(dot)ru>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] MVCC works in serialized mode!
Date: 1998-12-28 15:39:31
Message-ID: 3687A633.88097F88@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > 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...

- Tom

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-12-28 15:50:57 Re: [HACKERS] Re: NULL & NOT NULL
Previous Message Theo Kramer 1998-12-28 14:04:56 Re: [HACKERS] MVCC works in serialized mode!