Partitioning tables in django?

Question

PostgreSQL

class Ground(models.Model):
    cadastral_number = models.CharField(primary_key=True, max_length=24)
    area = models.FloatField(null=True)   # Если строительство незавершенно то значение 0
    district = models.CharField(max_length=120, blank=True, null=True)
    region = models.IntegerField( blank=True, null=True)          # dRegionsRF

And I implemented partitioning using table inheritance by region. Created rules, and it seems everything works. But when writing with related objects, an
insert or update on table "ground" violates foreign key constraint "classifier_ground_id_ff3a6d69_fk"
DETAIL: Key (ground_id)=(40:00:000000:196) is not present in table "ground" error occurs.

Answer 1

https://www.postgresql.org/docs/10/static/ddl-part...
Looks like FKs on a partitioned table are not supported. You can manually drop the constraint and carefully monitor the integrity of the database.