Re: ALTER TABLE OWNER: change indexes

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ALTER TABLE OWNER: change indexes
Date: 2002-02-24 23:20:09
Message-ID: Pine.LNX.4.30.0202241818570.686-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Tom Lane writes:

> Another point that maybe does need immediate attention: as coded,
> reassignment of ownership of a table won't affect the associated
> TOAST table, if any. Should it?

Maybe indexes and TOAST tables shouldn't have ownership it all. (Set
relowner to 0.) Since only owners can create these things, there doesn't
seem to be a point in maintaining ownership.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2002-02-24 23:33:07 Re: ALTER TABLE OWNER: change indexes
Previous Message Tom Lane 2002-02-24 22:43:07 Re: ALTER TABLE OWNER: change indexes