diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-08-04 01:09:29 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-08-04 01:09:29 +0000 |
| commit | 33f5bf97009811d7f6b5408e37c6ad68110985b0 (patch) | |
| tree | af599eafaa4b01a044de0e8e98f5eb16bbcd19aa /doc/src | |
| parent | e48b28b688c9dd1ad2d74fcfeed7d76fe63d0047 (diff) | |
| download | postgresql-33f5bf97009811d7f6b5408e37c6ad68110985b0.tar.gz postgresql-33f5bf97009811d7f6b5408e37c6ad68110985b0.zip | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 26dabbb79ec..8e1d2984249 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.78 2005/08/01 16:11:14 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.79 2005/08/04 01:09:27 tgl Exp $ PostgreSQL documentation --> @@ -235,7 +235,7 @@ where <replaceable class="PARAMETER">action</replaceable> is one of: <term><literal>OWNER</literal></term> <listitem> <para> - This form changes the owner of the table, index, sequence, or view to the + This form changes the owner of the table, sequence, or view to the specified user. </para> </listitem> |