Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group