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

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

pgsql-patches by date

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

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