Facing issue while migrating from sqllite to postgresql in Django

Question

I am getting below error when I am migrating from django SQLite to PostgreSQL.

django.db.utils.ProgrammingError: cannot cast type smallint to boolean
LINE 1: ... "merchant_view" TYPE boolean USING "merchant_view"::boolean

I am able to see all the tables in Postgresql even the table which is giving me above error. But in Postgresql its datatype have changed from Boolean to smallint. I am not also not able to change the datatype from smallint to boolean in postresql. Most of the fields has Boolean datatype in postgresql.I dont know what causing this error. How can i solve this error.

My Model
class ContractLineItems(CommomFields):
    payment_app_id = models.AutoField(primary_key = True)
    code = models.CharField(max_length=11,unique=True)
    module = models.ForeignKey(ContractManager,on_delete=models.CASCADE)
    description = models.CharField(max_length=255)
    buy_rate = models.DecimalField(max_digits=10,decimal_places=10)
    default_rev_share = models.DecimalField(max_digits=10,decimal_places=10)
    list_price = models.DecimalField(max_digits=10,decimal_places=10)
    billing_type = models.ForeignKey("BillingType",on_delete=models.CASCADE)
    merchant_view = models.BooleanField(default=False)
    bound_descreption = models.CharField(max_length=255)
    user_id = None
    trash = None
    deleted_at = None
    deleted_by = None

Thanks in Advance.

charanjeet singh · Accepted Answer · 2021-02-19 13:56:54Z

1

Issue Solved.

In Migration files field name merchant_view was first declared as smallPositiveInteger. So while migrating to postgresql it was accepting the first declaration. So I deleted all migrated files and ran makemigrations it worked for me

answered Feb 19, 2021 at 13:56

charanjeet singh

679 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Facing issue while migrating from sqllite to postgresql in Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related