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