Re: Voting systems & postgres transaction

2007-05-22 Thread ZebZiggle
Hmm, that's interesting Russ. So, if I understand what you are suggesting is a syntax that allows the operation to be performed in the database and not on the server? If the resultant sql utilizes a sub-query, that might be an issue (for the same concurrency problems as stated above). I think f

Re: Voting systems & postgres transaction

2007-05-21 Thread Russell Keith-Magee
On 5/21/07, ZebZiggle <[EMAIL PROTECTED]> wrote: > > UPDATE Content SET voteTotal = voteTotal + 1 WHERE id = ... > > Anyone have any thoughts on the problem? What am I missing? I've thought about this before; IMHO, the right solution is to provide an easy syntax for a Django query (or in this cas