> "Erik Aronesty" <erik@xxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend