Bram - Smartelectronix wrote:
> Rubic wrote:
>> Bram,
>>
>> Try removing (commenting out) the transaction decorator
>> and transaction.commit(), then re-run your code.  The
>> ProgrammingError exception may be hiding the real
>> exception.  At least that's been my experience.
> 
> Nope..., I'm really getting the "unique key violation" on order...

Uhm, please ignore this email, it looks like this can't be done using 
transactions

begin transaction;
update book set "order"=2 where id=1;
update book set "order"=1 where id=2;
commit;

ERROR: duplicate key violates unique constraint "book_order_key"

What a pitty!


  - bram

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

Reply via email to