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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026