ALTER TABLE OWNER must change the ownership of the table's rowtype too.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 33f5bf97009811d7f6b5408e37c6ad68110985b0
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2005-08-04T01:09:29Z
Releases: 8.1.0
ALTER TABLE OWNER must change the ownership of the table's rowtype too.
This was not especially critical before, but it is now that we track
ownership dependencies --- the dependency for the rowtype *must* shift
to the new owner.  Spotted by Bernd Helmle.
Also fix a problem introduced by recent change to allow non-superusers
to do ALTER OWNER in some cases: if the table had a toast table, ALTER
OWNER failed *even for superusers*, because the test being applied would
conclude that the new would-be owner had no create rights on pg_toast.
A side-effect of the fix is to disallow changing the ownership of indexes
or toast tables separately from their parent table, which seems a good
idea on the whole.

Files