Re: not bug after all, sorry for the noise - Mailing list pgsql-bugs

From Jeff Davis
Subject Re: not bug after all, sorry for the noise
Date
Msg-id 1177526933.28383.84.camel@dogma.v10.wvs
Whole thread Raw
In response to pg_dump doesn't properly honor -O for sequences  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-bugs
On Wed, 2007-04-25 at 11:36 -0700, Jeff Davis wrote:
> pg_dump -O apparently removes all instances of ALTER TABLE ... OWNER TO
> from the output, but does not remove ALTER SEQUENCE ... OWNED BY from
> the output.
>
> Specifically this is with SERIAL sequences, which are dumped using the
> ALTER SEQUENCE syntax (as of 8.2). Normal sequences are dumped using the
> ALTER TABLE ... OWNER TO syntax, which properly honors -O.
>

Sorry for the noise. I misinterpreted the meaning of OWNED BY to mean
the user who owns, not the table who owns.

Regards,
    Jeff Davis

pgsql-bugs by date:

Previous
From: Jeff Davis
Date:
Subject: pg_dump doesn't properly honor -O for sequences
Next
From: Tom Lane
Date:
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect