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 -~----------~----~----~----~------~----~------~--~---