Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: alter table serial->int
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Erik Aronesty <erik(at)q32(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: alter table serial->int
- Date: Thu, 8 Nov 2007 16:57:21 -0300
Erik Aronesty wrote: > -- Simpler example for you > > CREATE TABLE x ( > id serial NOT NULL > ); > > ALTER TABLE x alter id type int; > > -- Under 8.1.10, a call to pg_dump will reveal the change has not happened Do an ALTER TABLE DROP DEFAULT instead. SERIAL is a macro for "int with a default". -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
- Follow-Ups:
- Re: alter table serial->int
- From: Erik Aronesty
- Re: alter table serial->int
- References:
- alter table serial->int
- From: Erik Aronesty
- Re: alter table serial->int
- From: Tom Lane
- Re: alter table serial->int
- From: Erik Aronesty
- alter table serial->int
- Prev by Date: Re: alter table serial->int
- Next by Date: Re: alter table serial->int
- Previous by thread: Re: alter table serial->int
- Next by thread: Re: alter table serial->int
- Indexes: