Re: ALTER TABLE OWNER: change indexes

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: ALTER TABLE OWNER: change indexes
Дата
Msg-id 200203110219.g2B2Jde11121@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: ALTER TABLE OWNER: change indexes  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: ALTER TABLE OWNER: change indexes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: ALTER TABLE OWNER: change indexes