Re: AW: Status of new relation file naming - Mailing list pgsql-hackers

From Philip Warner
Subject Re: AW: Status of new relation file naming
Date
Msg-id 3.0.5.32.20000914192825.00c7d140@mail.rhyme.com.au
Whole thread Raw
In response to AW: Status of new relation file naming  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
At 10:00 14/09/00 +0200, Zeugswetter Andreas SB wrote:
>
>> > My vote is for a random number, and then someone can write 
>> > the tools to display the file info. I'll even volunteer to
>> > work on them...
>
>What was the advantage of random number over oid [+version]
>in the light that there is an extra field in pg_class for other smgrs ?

None other than it removes the temptation to write utilities that rely on
the internal representation of our data.


>We surely want readable names for tablespace files, no ?

So long as we say from the outset that 'rename tablespace' must be done
outside of transactions, and while the database (or at least the tables
that it contains) are not available.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/


pgsql-hackers by date:

Previous
From: Dana.Reed@clinicaldatacare.com
Date:
Subject: RE: List funnies ?
Next
From: Philip Warner
Date:
Subject: pg_dump of regression (again)