Re: [BUGS] pg_dump doesn't properly honor -O for sequences

2007-04-25 Thread Jeff Davis
On Wed, 2007-04-25 at 16:44 -0400, Tom Lane wrote: > Jeff Davis <[EMAIL PROTECTED]> 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

Re: [BUGS] pg_dump doesn't properly honor -O for sequences

2007-04-25 Thread Tom Lane
Jeff Davis <[EMAIL PROTECTED]> 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

[BUGS] pg_dump doesn't properly honor -O for sequences

2007-04-25 Thread Jeff Davis
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