> "Erik Aronesty" <erik(at)q32(dot)com> writes: > > for some odd reason when i try to change a table from serial to just > > plain "int with a default" postgres seems to ignore me. > > What PG version? (PostgreSQL) 8.1.10 > The fact that you even tried that suggests that you don't understand > very well what "serial" is. See the manual ... I tried to change the data type first. Which implies I know what it means.