Re: pg_dump fails to set index ownership

On Fri, Sep 23, 2005 at 04:45:02PM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Michael Fuhr <mike@fuhr.org> writes:
> > > Regarding the removal of ALTER INDEX OWNER commands from pg_dump,
> > > indexes are now restored with the wrong ownership if the user doing
> > > the restore is different than the user who owned the original index
> > 
> > pg_dump is not the source of the problem.  We should instead arrange
> > that an index's relowner value is copied directly from the parent table
> > during CREATE INDEX.  This is probably more important now with roles,
> > since GetUserId() might not have a lot to do with the table's owner ID.
> 
> My testing indicated this is fixed.

Tom fixed it shortly after making that post:

http://archives.postgresql.org/pgsql-committers/2005-08/msg00347.php

-- 
Michael Fuhr