"Erik Aronesty" <erik@xxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster