On Fri, Sep 23, 2005 at 04:45:02PM -0400, Bruce Momjian wrote: > 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.
Tom fixed it shortly after making that post: http://archives.postgresql.org/pgsql-committers/2005-08/msg00347.php -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq