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_sql cursor.execute(sql, params) ProgrammingError: operator does not exist: character varying = integer LINE 1: ...ons_submission" WHERE "submissions_submission"."status" = 0 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. using postgres 8.3. any advise would help. including up/downgrading postgres (seems to be a lot of issues on the trac, is 8.3 even supported?) -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=.
