Re: Disable Transaction - plans ?

> Mike Mascari <mascarm(at)mascari(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026