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

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.
        regards, tom lane