Re: pg_dump fails to set index ownership

On Mon, Jan 10, 2005 at 07:28:52PM -0700, Michael Fuhr wrote:

> pg_dump fails to set ownership on indexes.

Is this a bug in pg_dump, or is it perhaps a bug in CREATE INDEX?
Is there any reason CREATE INDEX shouldn't set the index owner to
be the same as the table owner?

For pg_dump's part, it's issuing ALTER TABLE OWNER TO immediately
after creating the table but before populating it and creating the
indexes.  If ALTER TABLE OWNER TO were issued after creating the
indexes then the ownership would cascade to the indexes.  Or pg_dump
could issue ALTER INDEX OWNER TO statements after creating the
indexes.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/