Обсуждение: pg_dump doesn't properly honor -O for sequences
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
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
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
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