[ 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 django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CALKD1M-YbR80USkq%2BLLyWHR7iem66ALcc9bH6dYGOEP9ywWkfA%40mail.gmail.com.
