Re: BUG #3869: A scenario where pg_dump doesn't dump sequence

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "guillaume (ioguix) de Rorthais" <ioguix(at)free(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3869: A scenario where pg_dump doesn't dump sequence
Date: 2008-01-12 18:23:56
Message-ID: 16662.1200162236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"guillaume (ioguix) de Rorthais" <ioguix(at)free(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-01-12 23:35:16 Re: BUG #3860: xpath crashes backend when is querying xmlagg result
Previous Message guillaume (ioguix) de Rorthais 2008-01-12 17:13:04 BUG #3869: A scenario where pg_dump doesn't dump sequence