Tim,
Actually thanks!
Once I put it into a function with the @transaction.commit_manually
decoration and manually commited: it worked fine.
Thanks again,
Dan
On Jul 11, 11:32 am, Dannoo <[EMAIL PROTECTED]> wrote:
> I tried that and got "serialized connection: cannot commit on this
> cursor"
> Also tried close with no results.
>
> On Jul 11, 11:29 am, Tim Chase <[EMAIL PROTECTED]> wrote:
>
> > > I am wondering why does this code does not work. The sql runs fine
> > > fine when executed through the postgres admin.
>
> > > from django.db import connection
>
> > > cursor = connection.cursor()
> > > x = cursor.execute("UPDATE videos_video SET name = 'Please work'
> > > WHERE videos_video.id = 1; " )
>
> > I know I've butted heads against remembering to commit the
> > transaction when done. I don't know what your current
> > transaction/commit settings are, but it might not hurt to do a
> > connection.commit() call in there when you're done.
>
> > -tim
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
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=en
-~----------~----~----~----~------~----~------~--~---
