On 2/3/06, tnleeuw <[EMAIL PROTECTED]> wrote:
> Besides the unicode-problem mentioned in another post, I have a problem
> where it seems 1 directory-name, 'NEW', seems to confuse the system. It
> might be a problem with PsycoPG... perhaps with Django... I don't know.
>
> The error which I get is:
>
> Exception Type: ProgrammingError
> Exception Value: ERROR: NEW used in query that is not in a rule INSERT
> INTO "photoalbum_dirs"
> ("name","parent_id","full_path","description","visited_in_browser")
> VALUES (NEW,9,DownloadedTrainPhotos/NEW,'',False)
> Exception Location:
> c:\Python24\lib\site-packages\django\core\db\base.py in execute, line
> 9
Hey Tim,
The problem here is that psycopg isn't quoting the values you're
passing to the query. I suspect this is happening because you're
passing Unicode strings instead of normal strings. Try running the
.encode() method on each Unicode string before passing it to the
database API, so that this:
f = foos.Foo(name=name, full_path=full_path, description=description)
...becomes this:
f = foos.Foo(name=name.encode(), full_path=full_path.encode(),
description=description.encode())
I believe the next version of psycopg fixes this, but we don't have a
Django driver for it yet because psycopg 2 is still in beta. That
said, somebody wrote one already; try searching the django-users (or
django-developers) archives for the patch.
Adrian
--
Adrian Holovaty
holovaty.com | djangoproject.com | chicagocrime.org
