Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #5152: Exporting databases with pg_dump changes 'bigserial' to 'bigint'
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: "S. 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: Fri, 30 Oct 2009 15:01:47 -0300
- Message-id: <20091030180147.GG4003@alvh.no-ip.org> <text/plain>
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
- References:
- Prev by Date: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- Next by Date: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
- Previous by thread: BUG #5152: Exporting databases with pg_dump changes 'bigserial' to 'bigint'
- Next by thread: BUG #5153: Problem configuring postgresql-8.5alpha2 with SSL
- Indexes: