Re: alter table serial->int

"Erik Aronesty" <erik@q32.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