"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> On Tue, Nov 18, 2008 at 10:24 AM, Simon Connah
> <simon.n.connah@btopenworld.com> wrote:
>> But whenever I try and update my column to this type it says that it can not
>> find that data type. Am I doing something wrong?
> Serial is a "pseudotype".
Perhaps better to say it's a macro, which is currently recognized by
column creation but not ALTER COLUMN TYPE. In recent versions you could
do "ALTER TABLE ADD COLUMN foo serial", if that helps.
I'm not sure if it'd be sensible to allow "ALTER COLUMN TYPE serial";
it seems like that might do more than you were expecting. ALTER TYPE
is a pretty low-level operation, imo.
regards, tom lane