Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: ALTER TABLE OWNER: change indexes
Date
Msg-id Pine.LNX.4.30.0202241818570.686-100000@peter.localdomain
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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tree view 
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@gmx.net

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER TABLE OWNER: change indexes
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE OWNER: change indexes