pg_dump doesn't properly honor -O for sequences

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dump doesn't properly honor -O for sequences
Date: 2007-04-25 18:36:32
Message-ID: 1177526192.28383.81.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2007-04-25 18:48:53 Re: not bug after all, sorry for the noise
Previous Message Tom Lane 2007-04-25 14:22:25 Re: Postmaster can't stop with pg_ctl