Re: Disable Transaction - plans ?

> Mike Mascari <mascarm@mascari.com> writes:
> > In fact, some could argue that the default behavior of PostgreSQL
> > should be changed (or at least have an option) to behave like
> > Oracle, where a transaction is implicitly begun at the first
> > encounter of an INSERT/UPDATE/DELETE - or in PostgreSQL's case, the
> > first submitted statement.
>
> If we put in an implicit BEGIN at the start of a connection, when
> does it get committed?  We certainly dare not do an implicit COMMIT
> when the client disconnects, but without that the change would
> completely break a lot of existing applications.
>
> Personally I'm perfectly happy with the notion that clients who want
> this behavior can send a BEGIN for themselves ...

In Ingres, you typically do 'SET AUTOCOMMIT ON' and it says that way for
the rest of the session.  GUC would have a default setting for
AUTOCOMMIT too.

There is no plan to change the default, just to allow people to modify
the default.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026