Thread: Re: [HACKERS] drop table inside transactions

Re: [HACKERS] drop table inside transactions

From
Zeugswetter Andreas SARZ
Date:
    >> Meskes, Michael wrote:
    >> >
    >> > 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.
    >
    >SOLID restores a dropped table with rollback.

    Same with Informix.

Re: [HACKERS] drop table inside transactions

From
Bruce Momjian
Date:
>
>     >> Meskes, Michael wrote:
>     >> >
>     >> > 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.
>     >
>     >SOLID restores a dropped table with rollback.
>
>     Same with Informix.
>
>

Added to TODO list:

    * Allow table creation/destruction to be rolled back

--
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)