> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
>
> > "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
>
Please add my opinion for naming rule.
relname/unique_id but need some work new pg_class column,
no relname change. for unique-id generation filename not relname
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp