Re: Disable Transaction - plans ?
| От | Bruce Momjian |
|---|---|
| Тема | Re: Disable Transaction - plans ? |
| Дата | |
| Msg-id | 200110250058.f9P0w7q14851@candle.pha.pa.us обсуждение исходный текст |
| Ответ на | Re: Disable Transaction - plans ? (Mike Mascari <mascarm@mascari.com>) |
| Список | pgsql-general |
> 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. That would make PostgreSQL behave much
> better out-of-the-box in comparison to mySQL, and would satiate the
> desires of those Oracle folks transitioning to PostgreSQL that do a:
>
> DELETE FROM foo;
> -- Nuts!
> ROLLBACK;
>
> and expect their DELETE to be undone.
TODO has:
* Allow autocommit so always in a transaction block
--
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
В списке pgsql-general по дате отправления: