Re: [HACKERS] drop table inside transactions

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] drop table inside transactions
Дата
Msg-id 199804171448.KAA20560@candle.pha.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] drop table inside transactions  ("Meskes, Michael" <meskes@topsystem.de>)
Список pgsql-hackers
>
> Is this really a bug? I haven't seen any (commercial) system supporting
> this kind of transaction recovery. Once you drop a table the data is
> lost, no matter if you rollback or not.
>
> Michael
>

Meta-data changes, like drop table, are not roll-back-able.  I knew this
was a reported problem, but I don't think it is required by standard, so
it is not on the TODO list.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Meskes, Michael"
Дата:
Сообщение: RE: [HACKERS] drop table inside transactions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Anyone working on asynchronous NOTIFY reception?