Thank you for answering. Just to be sure: you agree that the behavior I describe looks like a bug somewhere?
man. 12. okt. 2020, 23:42 skrev Thomas Lockhart <[email protected]>: > No one has answered yet, so here is some useless info… > > I’ve been using various combinations of Postgres and Django (currently > 12.4 and 3.1.2, respectively) and would think I would have stumbled on this > at some point when using postgresql-11. But I probably haven’t tried 11.x > with 3.1.2 specifically… > > - Tom > > On Oct 12, 2020, at 9:24 AM, Joakim Hove <[email protected]> wrote: > > [ This question is also posted to StackOverflow: > https://stackoverflow.com/questions/64320386/django-postgresql-model-with-only-foreign-keys > ] > > I have a model which looks like this: > > class InputTypeMap(models.Model): > input_type = models.ForeignKey(InputType, on_delete=models.CASCADE) > training = models.ForeignKey(Training, on_delete=models.CASCADE) > category = models.ForeignKey(Category, on_delete=models.CASCADE) > gender = models.ForeignKey(Gender, on_delete=models.CASCADE) > > When I try to create instances of this model with: > > InputTypeMap.objects.create(input_type=input_type, > training=training, > gender=gender, > category=category) > > I get an exception when using Postgres-11.9: > > Traceback (most recent call last): > File > "/home/hove/sleipner/venv/lib/python3.7/site-packages/django/db/backends/utils.py", > line 84, in _execute > return self.cursor.execute(sql, params) > psycopg2.errors.NotNullViolation: null value in column "id" violates not-null > constraint > DETAIL: Failing row contains (null, Maintenance, Female, MareGielding, No). > > From the error message it seems to me that a ID key for the new entry is > not generated. This code has worked as I expected for quite some time, but > has "suddenly" started to fail locally - probably after a apt get upgrade. > When I run the same code with sqlite or Postgres-10.14 thing continue to > work as before. It is not clear to me whether this is a bug in my code > (most probable ...), Django or Postgres. I am using Django version 3.1.2 > > Any hints appreciated. > > Regards - Joakim Hove > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CALKD1M-YbR80USkq%2BLLyWHR7iem66ALcc9bH6dYGOEP9ywWkfA%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CALKD1M-YbR80USkq%2BLLyWHR7iem66ALcc9bH6dYGOEP9ywWkfA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/1C816206-3EC7-4696-806E-FD810E76C251%40gmail.com > <https://groups.google.com/d/msgid/django-users/1C816206-3EC7-4696-806E-FD810E76C251%40gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALKD1M8O4%3DtQ%2BxuEE7%2BzC17%2BjnotzUzEDU3EkoqVTPDOTngQMg%40mail.gmail.com.
