Re: pg_dump fails to set index ownership - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_dump fails to set index ownership
Date
Msg-id 12926.1105424034@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump fails to set index ownership  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Michael Fuhr <mike@fuhr.org> writes:
> On Tue, Jan 11, 2005 at 12:25:31AM -0500, Tom Lane wrote:
>> A related point is that ALTER TABLE ... OWNER does not recurse to
>> the table's indexes.

> Eh?  ALTER TABLE ... OWNER won't touch the indexes if the table
> owner doesn't change, but if the table owner changes then so do
> the index owners.

[ scratches head ... ]  Looking at the code, you're right.  I'm not sure
what I did wrong in the quick test that led me to conclude otherwise.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1381: invalid input syntax for integer: ""
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Returned due to virus; was:Hello