Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> 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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
