postgres error: type "serial" does not exist
I want to migrate my my changes but i get this
error: type "serial" does not exist.
This is my schema:
6 Replies
my imports
I'm not 100% sure but I believe you can't use serial in
alter table
statements.Take a look here. If you're attempting to migrate a column from any other type to serial: https://stackoverflow.com/questions/27307835/how-to-convert-primary-key-from-integer-to-serial
Stack Overflow
How to convert primary key from integer to serial?
In a Postgres 9.3 table I have an integer as primary key with automatic sequence to increment, but I have reached the maximum for integer. How to convert it from integer to serial?
I tried:
ALTER ...
Its a new table, if that makes a difference. Any idea how I could fix it?
I would just use integer as a workaround
I fixed it, flushed my db, and added a new pk column using serial
The other are text Ids now