I am trying to understand why Django (or PostgreSQL, not sure at what level it is) does not reuse primary keys from remote objects. When objects are created, they all have an id value, which is automatically incremented and ordered by the id value in the database. For example:
ID
5
4
3
2
1
Let's say I manage to delete the object with id 5:
ID
4
3
2
1
When I create a new object, it has an identifier of 6:
ID
6
4
3
2
1
Why was "5" not assigned as the primary key for the new object that I just created? Why does he have 6 instead?