Re: [HACKERS] DROP TABLE inside a transaction block
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Mike Mascari <mascarm@mascari.com>, Peter Eisentraut <peter_e@gmx.net>, Tatsuo Ishii <t-ishii@sra.co.jp>, pgsql-hackers@postgreSQL.org
Date: 2000-03-08T01:13:53Z
Lists: pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes: >> BTW, we are not *that* far from being able to roll back a DROP TABLE. >> The only thing that's really needed is for everyone to take a deep >> breath and let go of the notion that table files ought to be named >> after the tables. If we named table files after the OIDs of their >> tables, then rollback-able DROP or RENAME TABLE would be pretty >> straightforward. If you don't recall why this is, consult the >> pghackers archives... > The oid will be appended to the base file name. If we do it that way, then RENAME TABLE will be kinda complicated... not impossible, but is it worth it? regards, tom lane