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
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
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
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