Bruce Momjian <pgman@candle.pha.pa.us> writes: >> Is it also desired to convert an int column to a serial column?
> I think the only sane solution is if a SERIAL column is changed to > INTEGER, the default and dependencies are removed. Do you want a TODO > for that? If we are going to do something like that, I think we should take a hard look at the idea I floated of putting SERIAL back to a pure creation-time macro for type and default expression. This is getting to have way too much hidden behavior, and what we are buying for it is very little as of 8.1. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster