Re: ALTER TABLE OWNER: change indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ALTER TABLE OWNER: change indexes
Date: 2002-03-05 23:34:19
Message-ID: 19386.1015371259@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> writes:
> Sure. The attached patch makes ALTER TABLE OWNER change the ownership of
> any indexes belonging to the target table,

What about TOAST tables (and their indexes)? If you intend to take this
approach then their ownership needs to change too.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Eiji Tokuya 2002-03-06 00:33:17 Re: Added Encoding
Previous Message Neil Conway 2002-03-05 21:17:42 Re: ALTER TABLE OWNER: change indexes