Re: [HACKERS] Happy column dropping
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Hiroshi Inoue" <Inoue@tpf.co.jp>
Cc: "Peter Eisentraut" <peter_e@gmx.net>, "The Hermit Hacker" <scrappy@hub.org>, "PostgreSQL Development" <pgsql-hackers@postgreSQL.org>, "Bruce Momjian" <pgman@candle.pha.pa.us>
Date: 2000-01-25T00:25:43Z
Lists: pgsql-hackers
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes: > As far as I see,fixed mapping relname to relation filename is the > problem. This doesn't allow the coexistence of old and new relation > files. Yes, and Vadim has proposed using relation OIDs as filenames for reasons of his own, IIRC. If we did that we could also solve the problems we have now with rolling back table deletion/rename inside an aborted transaction. I've been resisting this idea, but maybe it's time to bite the bullet and accept that relation filenames can't be the same as the logical names of the relations. regards, tom lane