Re: OK, OK, Hiroshi's right: use a seperately-generated filename

Chris Bitmead <chris@bitmead.com>

From: Chris Bitmead <chris@bitmead.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgreSQL.org
Date: 2000-06-18T01:07:18Z
Lists: pgsql-hackers
Tom Lane wrote:

> > Also, you said before that an old relname (after rename) is worse than
> > none at all. I couldn't agree more.
> 
> I'm not the one who wants relnames in the physical names ;-).  However,
> this implementation mechanism will support either policy choice ---
> original relname in the filename, or just a numeric ID for the filename
> --- and that seems like a good sign to me.
> 
> > Why not use OID.[SEGMENT.]VERSION for the physical relname (different
> > order possible)?

Unless VERSION is globally unique like an oid is, having RELNAME.VERSION
would be a problem if you created a table with the same name as a 
recently renamed table.