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

From Michael Fuhr
Subject Re: pg_dump fails to set index ownership
Date
Msg-id 20050923214608.GA3106@winnie.fuhr.org
Whole thread Raw
In response to Re: pg_dump fails to set index ownership  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Basic documentation for ROLEs.
Next
From: Tom Lane
Date:
Subject: Re: ALTER ROLES - questions