Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5152: Exporting databases with pg_dump changes 'bigserial' to 'bigint' - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #5152: Exporting databases with pg_dump changes 'bigserial' to 'bigint'
Date
Msg-id 20091030180147.GG4003@alvh.no-ip.org
Whole thread Raw
In response to BUG #5152: Exporting databases with pg_dump changes 'bigserial' to 'bigint'  ("S. Neumann" <simon.neumann@communology.com>)
List pgsql-bugs
Tree view 
S. Neumann wrote:

> When exporting databases using pg_dump column types that are 'bigserial'
> become 'bigint'. This problem did not occur on 8.0.8 on linux.

Yeah, but this is not a bug.  There are later commands that attach a
sequence to the default value of the column, effectively turning it into
a bigserial.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault