On Thu, 15 Jun 2000, Bruce Momjian wrote:
> > "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > > Now I like neither relname nor oid because it's not sufficient
> > > for my purpose.
> >
> > We should probably not do much of anything with this issue until
> > we have a clearer understanding of what we want to do about
> > tablespaces and schemas.
>
> Here is an analysis of our options:
>
> Work required Disadvantages
> ----------------------------------------------------------------------------
>
> Keep current system no work rename/create no rollback
>
> relname/oid but less work new pg_class column,
> no rename change filename not accurate on
> rename
>
> relname/oid with more work complex code
> rename change during
> vacuum
>
> oid filename less work, but confusing to admins
> need admin tools
My vote is with Tom on this one ... oid only ... the admin should be able
to do a quick SELECT on a table to find out the OID->table mapping, and I
believe its already been pointed out that you cant' just restore one file
anyway, so it kinda negates the "server isn't running problem" ...