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 <[email protected]> wrote: > 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 databases will automatically cast > things that look like integers to integers if needed for comparison, > but newer postgresql, and probably others, in time, require you to > say what you mean, and this is probably a (tm) good thing, in that > the automatic casting hides subtle bugs that are hard to find. > > Or you could downgrade postgresql if you like. But eventually you're > likely to want some new feature, so fixing your column seems to me > the right thing. > > Bill > > > > On Mon, Nov 23, 2009 at 1:17 PM, Some Guy <[email protected]> wrote: > > 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 [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/django-users?hl=. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=.
