default integer value for non-primary field in django with postgresql

Question

I have a non-primary key integer field in my Django model and I use Postgresql for database.

class TestModel(models.Model)
    pid = models.IntegerField(blank=True)
    some_field = models.CharField()

I want my pid field to have default values, that appear in database, I set the serial type for the pid field on the DB side

alter column pid type serial not null;

but when I create some record without without specifying value for pid, Django gives an error "null value in column "pid" violates not-null constraint", although it works fine when inserting data via SQL directly into database. I found this Django and PostgreSQL sequence for primary key autoincrement, but it's not working for me

Alvi15 · Accepted Answer · 2020-11-10 08:01:15Z

0

According to the documentation, you need to use AutoField. Like:

pid = models.AutoField(blank=true)

because what you change in database doesn't reflect to your Django immediately, better of changing your model and migrate your changes.

answered Nov 10, 2020 at 8:01

Alvi15

3352 silver badges10 bronze badges

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

3 Comments

dreamquester Over a year ago

I tried this, but it says "AutoFields must set primary_key=True".

Alvi15 Over a year ago

stackoverflow.com/questions/41228034/… well the other way is to do this. @dreamquester

dreamquester Over a year ago

yeah, I am thinking of this too, I created a method like this, but thought I could do it without additional methods, just on DB side. Thank you.

Saket B · Accepted Answer · 2020-11-10 08:06:17Z

0

You can generate the default values or use the AutoFiled.

https://docs.djangoproject.com/en/3.1/ref/models/fields/#default

After making changes to your models, always use makemigrations and migrate to reflect the changes into the db.

answered Nov 10, 2020 at 8:06

Saket B

412 silver badges6 bronze badges

1 Comment

dreamquester Over a year ago

It seems that there is no way to avoid inserting null value into a field, when saving a model object and I really have to use signals or create some method to generate a default value. Thanks

Collectives™ on Stack Overflow

default integer value for non-primary field in django with postgresql

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related