AutoField has to have a primary key, but I have a column we want to increment. It’s a kind of account ID that we want to generate, but we don’t want to have them as the primary key as it’s a bit inflexible if we want to change the scheme at some point in the future, and at the moment all our models …

We had a similar situation - what we had done was create the SERIAL column directly in the database using SQL, and defined the field in the model as an IntegerField. (If we had to do it again, we’d probably define the field as a custom migration.)

We are also looking to do something similar. We created a custom migration script that does the creates a column short_url_ref in our model. However, what I don’t understand is that you said you defined the field in the model as an IntegerField - is it like a place holder or do you run migration aga…

[image] grandimam: However, what I don’t understand is that you said you defined the field in the model as an IntegerField - is it like a place holder or do you run migration again: Yes, we ran makemigrations, primarily to ensure that Django knows that the models match the database. But since…

When you ran make migrations didn’t Django complain about IntegerField() being non-nullable? When I run makemigrations I get a prompt asking to define the field as nullable - which in turn creates another migration script that adds the field. If it’s not too much to ask it would be really helpful if…

[image] grandimam: When you ran make migrations didn’t Django complain about IntegerField() being non-nullable? Honestly, I don’t recall. Regardless, it didn’t matter because the migrate was run with the --fake parameter, which meant that nothing in the migration was going to be performed any…

I developed django-sequencefield that address exactly that case: [image] GitHub - quertenmont/django-sequencefield: Additional field from django taking it's value... Additional field from django taking it's value from a postgresql sequence. It is similar to django AutoField, exce…

Non-primary key database sequence

Using Django Using the ORM

tom April 29, 2024, 4:31pm 4

There is another possibility mentioned here: Django 4.2, is a 2nd autofield-like field on a model possible? - #4 by jaddison

Topic		Replies	Views
How to use sequences Using the ORM	1	5415	June 28, 2022
Django 4.2, is a 2nd autofield-like field on a model possible? Using the ORM	5	1217	June 8, 2024
SerialFields - Yay or Nay? ORM	25	1332	December 19, 2024
How to implement non integer default auto fields ORM	2	50	December 22, 2025
Rationale for unique AutoField's Using the ORM	8	725	August 31, 2023

Non-primary key database sequence

Related topics