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