Re: BUG #5152: Exporting databases with pg_dump changes 'bigserial' to 'bigint'

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "S(dot) Neumann" <simon(dot)neumann(at)communology(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5152: Exporting databases with pg_dump changes 'bigserial' to 'bigint'
Date: 2009-10-30 18:01:47
Message-ID: 20091030180147.GG4003@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2009-10-30 18:22:53 Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Previous Message Stefan Kaltenbrunner 2009-10-30 17:58:01 Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault