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.