Thom Brown <thom(at)linux(dot)com> writes:
> Would it be possible (or reasonable) to add support for changing the type of
> a column to serial or bigserial (yes, yes, I know they're not actual
> types)?

We've looked at that in the past and decided there were enough corner
cases that it wasn't clearly a good idea.  In particular, what do you do
with the existing data in the column?  What do you do if there's already
a DEFAULT expression for the column, throw it away?  In particular, what
of the special case that the column is in fact already a serial, so the
default is pointing at an existing sequence?

It is possible to accomplish everything that such a command would do
manually, so the argument for having it boils down to wanting it to
be a bit easier.  But unless the command can always do the right thing
automatically, I'm not sure "easy" is a good argument.

There's also the objection that such an operation would actually have
very little to do with ALTER COLUMN TYPE --- most of the things it would
do are not that.  The fact that serial was bolted on as a fake type is a
wart that maybe we shouldn't extend in this particular fashion.

			regards, tom lane

In response to

• Alter column to type serial at 2010-11-04 12:05:01 from Thom Brown

Responses

• Re: Alter column to type serial at 2010-11-04 14:12:23 from Thom Brown

pgsql-hackers by date

Next:	From: Dimitri Fontaine	Date: 2010-11-04 14:06:48
	Subject: Re: ALTER OBJECT any_name SET SCHEMA name
Previous:	From: Robert Haas	Date: 2010-11-04 14:04:55
	Subject: Re: contrib: auth_delay module