Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3869: A scenario where pg_dump doesn't dump sequence - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3869: A scenario where pg_dump doesn't dump sequence
Date
Msg-id 16662.1200162236@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3869: A scenario where pg_dump doesn't dump sequence  ("guillaume (ioguix) de Rorthais" <ioguix@free.fr>)
List pgsql-bugs
Tree view 
"guillaume (ioguix) de Rorthais" <ioguix@free.fr> writes:
> I think I found a bug in pg_dump from PostgreSQL 8.1.

> When creating a table with a SERIAL column, thn alter this column as
> smallint, pg_dump doesn't create the sequence anymore.

This is fixed (along with lots of other corner cases for altered serial
columns) in 8.2.  In prior releases, serial columns are best treated
as black boxes.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "guillaume (ioguix) de Rorthais"
Date:
Subject: BUG #3869: A scenario where pg_dump doesn't dump sequence
Next
From: Tom Lane
Date:
Subject: Re: BUG #3860: xpath crashes backend when is querying xmlagg result