Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: alter table serial->int
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Erik Aronesty" <erik(at)q32(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: alter table serial->int
- Date: Wed, 07 Nov 2007 00:11:10 -0500
"Erik Aronesty" <erik(at)q32(dot)com> writes: > for some odd reason when i try to change a table fromserial to just > plain "int with a default" postgres seems to ignore me. What PG version? I'd expect this to work somewhat sanely in 8.2, but in earlier versions fooling with the default expression for a serial column is not well supported. > alter table custom alter id type int; The fact that you even tried that suggests that you don't understand very well what "serial" is. See the manual ... regards, tom lane
- Follow-Ups:
- Re: alter table serial->int
- From: Erik Aronesty
- Re: alter table serial->int
- References:
- alter table serial->int
- From: Erik Aronesty
- alter table serial->int
- Prev by Date: Re: Vacuum Doesn't Recover Disk Space
- Next by Date: Re: Source of pgpool2 manual
- Previous by thread: alter table serial->int
- Next by thread: Re: alter table serial->int
- Indexes: