Re: ALTER TABLE OWNER: change indexes - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: ALTER TABLE OWNER: change indexes
Date
Msg-id 200203110219.g2B2Jde11121@candle.pha.pa.us
Whole thread Raw
In response to Re: ALTER TABLE OWNER: change indexes  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-patches
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.

--
  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

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ALTER TABLE OWNER: change indexes
Next
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE OWNER: change indexes