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: pgsql-hackers@postgreSQL.org
Date: 2000-03-08T08:41:17Z
Lists: pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes: >> Bruce seems to be willing to accept a window of failure for RENAME >> TABLE in order to make database admin easier. That is very possibly >> the right tradeoff --- but it is *not* an open-and-shut decision. >> We need to talk about it. > How about creating a hard link during RENAME, and you can just remove > the old link on commit or remove the new link on transaction rollback? Still non-atomic as far as I can see... regards, tom lane