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

From Bruce Momjian
Subject Re: ALTER TABLE OWNER: change indexes
Date
Msg-id 200203050650.g256oMa26830@candle.pha.pa.us
Whole thread Raw
In response to Re: ALTER TABLE OWNER: change indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ALTER TABLE OWNER: change indexes
List pgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > OK, the issue with this patch is that it fixes ownership of INDEXES.
>
> I thought the resubmitted patch did no such thing?
>
> > Now, we are we going with this?  Can we just remove ownership of indexes
> > totally?  And sequences?
>
> How did you get from indexes to sequences?  The issues are completely
> different.

The poster mentioned it.  What does it matter?  I am asking.

> I'm in favor of considering that indexes and toast tables have no
> separate ownership, and storing zero in pg_class.relowner for them.
> However, I have not looked to see what this might break.  It might
> be more trouble than it's worth.

Well, before we reject this patch, we should decide what we are going to
do.  Of course, indexes are still in pg_class, and putting zero in there
for a user could be trouble.  It may be easier to just apply the patch.
In fact, because it is pg_class, I am not sure we will ever know what
3rd party apps we will break.

--
  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: Tom Lane
Date:
Subject: Re: ALTER TABLE OWNER: change indexes
Next
From: Bruce Momjian
Date:
Subject: Re: enable debugging in jdbc