Re: [BUGS] pg_dump fails to set index ownership

2005-01-10 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Tue, Jan 11, 2005 at 12:25:31AM -0500, Tom Lane wrote: >> A related point is that ALTER TABLE ... OWNER does not recurse to >> the table's indexes. > Eh? ALTER TABLE ... OWNER won't touch the indexes if the table > owner doesn't change, but if the tab

Re: [BUGS] pg_dump fails to set index ownership

2005-01-10 Thread Michael Fuhr
On Tue, Jan 11, 2005 at 12:25:31AM -0500, Tom Lane wrote: > A related point is that ALTER TABLE ... OWNER does not recurse to > the table's indexes. Eh? ALTER TABLE ... OWNER won't touch the indexes if the table owner doesn't change, but if the table owner changes then so do the index owners. I

Re: [BUGS] pg_dump fails to set index ownership

2005-01-10 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > 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 sa

Re: [BUGS] pg_dump fails to set index ownership

2005-01-10 Thread Michael Fuhr
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