On Apr 18, 1:42 pm, msoulier <msoul...@digitaltorque.ca> wrote:
>         cursor.execute("""
>             BEGIN;
>             UPDATE clients
>             SET connected = 'false'
>             WHERE connected = 'true'
>             AND tugid <> %s;
>             COMMIT;""", [local_tugid])

And, of course, just after posting this I found the issue.

I put a BEGIN; COMMIT; around the snippet because in postgres the
commands didn't seem to do anything. I foolishly didn't find out why
it worked when I used a sub-transaction. So now my question is why
this didn't seem to work without using one.

The quest for truth continues...

Mike
--~--~---------~--~----~------------~-------~--~----~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to