Re: [HACKERS] Happy column dropping

> "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,
Pennsylvania19026