Postgres doesn't support automatically altering an integer field to a serial field, see here. While you can do the conversion manually, it's probably easier to continue using an integer field, or to drop the table and recreate it.