Re: ALTER TABLE OWNER: change indexes

pgman wrote:
> Peter Eisentraut wrote:
> > Bruce Momjian writes:
> >
> > > OK, I propose that we do the index part of this patch too.  No one seems
> > > to know if seting the index user id to zero in pg_class will break
> > > things so we may as keep it consistent.  Can you send that over?
> >
> > What would it break?  Joins against pg_user should use outer joins anyway.
> > I don't think this is the right direction.  It's just a waste of code.
>
> To me, maintaining it is very low cost and we don't know for sure people
> are using outer joins for all their system table access. We only added
> outer joins in pg_dump and psql in the past year or two.

Actually, more to the point, the table owner does own the indexes.  I
know that is is always true, but if someone is spinning through pg_class
and wants to find everything owned by a specific person, without joining
to pg_index, keeping the user id correct on indexes is helpful.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026