PRIMARY KEY in view PostgreSQL

2017-12-11 Thread Matthew Pava
Fellow users, I have an unmanaged model that references a view in my PostgreSQL 9.5 backend. I am trying to apply an annotation through the ORM in that model's manager. Unfortunately, I am getting an error that some fields "must appear in the GROUP BY clause or be used in an aggregate function

Re: PRIMARY KEY in view PostgreSQL

2017-12-11 Thread Simon Charette
Hello Matthew, This should be fixed in Django 2.0 by daf2bd3efe53cbfc1c9fd00222b8315708023792[0]. I'd appreciate if you could chime in the related django-developer thread[1] to mention you were using an unmanaged model to query views as there was no consensus regarding whether or not the patch

RE: PRIMARY KEY in view PostgreSQL

2017-12-11 Thread Matthew Pava
Sent: Monday, December 11, 2017 1:35 PM To: Django users Subject: Re: PRIMARY KEY in view PostgreSQL Hello Matthew, This should be fixed in Django 2.0 by daf2bd3efe53cbfc1c9fd00222b8315708023792[0]. I'd appreciate if you could chime in the related django-developer thread[1] to mention you