"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