Re: pg_dump fails to set index ownership

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump fails to set index ownership
Date: 2005-01-11 06:13:54
Message-ID: 12926.1105424034@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-01-11 06:27:02 Bug form version numbers
Previous Message Tom Lane 2005-01-11 06:10:59 Re: BUG #1381: invalid input syntax for integer: ""