SEO

#1 (**permalink**) 04-10-2008, 10:45 AM

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.

Regards,
Jeff Davis

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#2 (**permalink**) 04-10-2008, 10:45 AM

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#3 (**permalink**) 04-10-2008, 10:45 AM

Jeff Davis <pgsql@j-davis.com> writes:
> 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.

Why should it? That's not ownership in the same sense.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#4 (**permalink**) 04-10-2008, 10:45 AM

On Wed, 2007-04-25 at 16:44 -0400, Tom Lane wrote:
> Jeff Davis <pgsql@j-davis.com> writes:
> > 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.
>
> Why should it? That's not ownership in the same sense.
>

I sent a retraction of the bug report quickly afterward. My apologies.

Regards,
Jeff Davis

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

pg_dump doesn't properly honor -O for sequences