Re: DROP TABLE in transaction - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: DROP TABLE in transaction
Date
Msg-id Pine.LNX.4.30.0104122132200.1148-100000@peter.localdomain
Whole thread Raw
In response to DROP TABLE in transaction  (David Olbersen <dave@slickness.org>)
Responses Re: DROP TABLE in transaction
List pgsql-sql
David Olbersen writes:

> I was wondering if anybody could explain to me why I can't roll back dropping a
> table.

Because DROP TABLE removes the table file on disk, and you can't roll back
that.  Actually, in 7.1 you can.  ;-)

> I would think that of all the events that should be rollback-able,
> dropping a table would be the first on the list.

Naah.  Insert and update are first.  ;-)

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: RE: RE: Re: select substr???
Next
From: David Olbersen
Date:
Subject: Re: DROP TABLE in transaction