Re: postgresql errors (works in sqlite)

gah, after a few hours of fighting with postgres, I missed that somehow, duh. I thought I had made it an int, sqlite3 was fixing it for me. thanks for the reply. On Nov 23, 10:35 am, Bill Freeman wrote: > counts[i] = Submission.objects.all().filter(status__exact=str(i)).count() > > If you really

Re: postgresql errors (works in sqlite)

counts[i] = Submission.objects.all().filter(status__exact=str(i)).count() If you really intended status to be an integer, you might prefer to alter your table to make the column the right type. The alter table command required is beyond my sql confidence. Older postgresql and lots of other datab

postgresql errors (works in sqlite)

Hi, I was switching from sqlite3 to postgres, the data was imported ok. But now certain view queries are failing. i.e. counts[i] = Submission.objects.all().filter(status__exact=i).count() fails with ... File "/usr/lib/python2.5/site-packages/django/db/models/sql/query.py", line 2369, in execute_