Re: [HACKERS] Happy column dropping
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Hiroshi Inoue <Inoue@tpf.co.jp>, Peter Eisentraut <peter_e@gmx.net>, The Hermit Hacker <scrappy@hub.org>, PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-01-25T02:51:51Z
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. > Yes, that is going to happen, clearly. New file names will be table_name+oid. Solves many problems. New file name will not be just oid. Too hard to administer. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026