| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE OWNER: change indexes |
| Date: | 2002-03-11 02:19:39 |
| Message-ID: | 200203110219.g2B2Jde11121@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-03-11 02:29:29 | Re: ALTER TABLE OWNER: change indexes |
| Previous Message | Peter Eisentraut | 2002-03-11 01:45:24 | Re: ALTER TABLE OWNER: change indexes |