Re: pg_dump fails to set index ownership

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.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073