Django with Postgresql, the column should appear in the GROUP BY clause or be used in an aggregate function

Question

I use Django 1.11 and Postgresql 9.6. My application has a model called Person, it has several fields. In a database, this is a materialized representation.

class Person(models.Model):
    personid = models.CharField(max_length=18, primary_key=True)
    count = models.BigIntegerField()
    native = models.CharField(max_length=2)
    ...

While doing

persons = Person.objects.values('personid', 'native')\
    .annotate(total=Count('native'))

It says psycopg2.ProgrammingError: column "person.native" must appear in the GROUP BY clause or be used in an aggregate function

When only select one column or do not set personification as a primary key or do not perform annotation , it will not receive an error.

I print the sql query:

SELECT
"person"."native",
"person"."personid",
COUNT("person"."native") AS "total"
FROM "person"
GROUP BY "person"."native", "person"."personid"

What can I do?

I make a presentation in the table and set the personification as the primary key, and then no problems.

Answer 1

Django >= 1.8 Django < 2,0. Django 2.0. , django-users.

, Django , PostgreSQL. PostgreSQL pk GROUP BY, . ( , .) PK PostgreSQL, , .

:

• https://github.com/django/django/commit/daf2bd3efe53cbfc1c9fd00222b8315708023792
• https://groups.google.com/forum/#!topic/django-developers/lx3ZSq-W9X4
• https://groups.google.com/d/msg/django-developers/lx3ZSq-W9X4/yh4I2CsoBwAJ
• https://code.djangoproject.com/ticket/28107