"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > On Tue, Nov 18, 2008 at 10:24 AM, Simon Connah > <simon.n.connah@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
