Type change error

[Olegt0rr]

Can't change field type with aerich

Example

State 1

class User(Model):
    id = CharField(max_length=32)

State 2

class User(Model):
    id = BigIntField()

Run upgrade

tortoise.exceptions.OperationalError: column "id" cannot be cast automatically to type bigint
HINT:  You might need to specify "USING id::bigint".

How to fix

Bad line (from migration)

ALTER TABLE "users" ALTER COLUMN "id" TYPE BIGINT;

Good line

ALTER TABLE "users" ALTER COLUMN "id" TYPE BIGINT USING id::bigint;

[long2ice]

Fixed, thanks!