composite primary key being dropped

[jnahorniak]

I am trying to use a composite primary key in postgres with Django/TimescaleDB (composite keys are new since Django 5.2). During the creation of the timescale hypertables, however, the primary key is automatically dropped by django-timescaledb (_drop_primary_key) just before the hypertable creation. Is there a workaround for this, or is this drop still required?

[juanbits]

im working around this, just now added in the migration a composite unique constrain, but now the problem is with the migrations when you want reference the TS model in other model's

examples:
base.TimeModel
id = models.AutoField(primary_key=True)
time = TimescaleDateTimeField

i migrate and added in the run migration a composite unique constrain (django-timescaledb forked code)

i apply the migrations...

now i add a new model
base.OtherModel
my_fk = ForeingKey(TimeModel)

make migrations ok, but when i try to apply the migration to create the new model, i got:
django.db.utils.ProgrammingError: there is no unique constraint matching given keys for referenced table "base_timemodel"

[juanbits]

i follow que instructions

then i create a unique constrain in the TableTs.Meta between (id, time) and in other models i reference a object via

class OtherModel(models.Model):
    name = models.CharField(max_length=20)
    tablets_id = models.IntegerField(null=True, blank=True)
    tablets_time = models.DateTimeField(null=True, blank=True)

    @property
    def related_tablets(self):
        """
        Retrieves the related TableTS instance based on tablets_id and tablets_time.
        """
        if self.tablets_id is not None and self.tablets_time is not None:
            return TableTs.objects.filter(id=self.tablets_id, time=self.tablets_time).first()
        return None

    def set_related_metric(self, tablets_instance):
        """
        Helper to set the tablets_id and tablets_time from a TableTs instance.
        """
        if tablets_instance:
            self.tablets_id = tablets_instance.id
            self.tablets_time = tablets_instance.time
        else:
            self.tablets_id = None
            self.tablets_time = None