Skip site navigation (1) Skip section navigation (2)

Re: ALTER TABLE OWNER: change indexes

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 (view raw or flat)
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

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-03-11 02:29:29
Subject: Re: ALTER TABLE OWNER: change indexes
Previous:From: Peter EisentrautDate: 2002-03-11 01:45:24
Subject: Re: ALTER TABLE OWNER: change indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group