Re: [HACKERS] Happy column dropping

> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026