Re: ALTER TABLE OWNER: change indexes

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(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