"Erik Aronesty" <[EMAIL PROTECTED]> 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
