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 по дате отправления: