Error : django_migrations.id has unsupported type "serial" with Amazon Redshift

I am trying to connect my django application with Amazon Redshift.I am using postgres pyscopg2 to connect from django to Redshift. But when i try to do syncdb or start the server, I receive below error

django.db.utils.NotSupportedError: Column "django_migrations.id" has unsupported type "serial". It seems Serial Datatype is not supported by Redshift. I tried creating a similar table in Redshift with Column 'ID' and type as 'Integer'. But it do not resolve the problem

How would I be able to resolve this issue?