Re: [RDBO] Possible to use load() to get a exclusive lock???

2007-04-11 Thread Perrin Harkins
On 4/11/07, John Siracusa [EMAIL PROTECTED] wrote: If you db supports it, you could try going into a serialized isolation mode and then doing all your operations in a single transaction. It does. SET TRANSACTION ISOLATION LEVEL repeatable read will cause all of your SELECT statements to be

Re: [RDBO] Possible to use load() to get a exclusive lock???

2007-04-10 Thread Jonathan Vanasco
On Apr 10, 2007, at 5:42 PM, Jeffrey Horn wrote: I'm trying to simulate named SEQUENCES (a la Oracle or Postgres) in MySQL (InnoDB). I have a table sequences with attributes name (varchar) and value (integer). Conceptually, I'd like to do this Assuming you're in Mysql5 -- can't you

Re: [RDBO] Possible to use load() to get a exclusive lock???

2007-04-10 Thread Ron Savage
Hi Jeffrey Is there something wrong with this package...? http://search.cpan.org/~adamk/DBIx-MySQLSequence-1.02/ Warning: All of Adam Kennedy's modules I have tried to install have been rigged to fail to install under Windows, but I assume you're using a real OS. -- Ron Savage [EMAIL PROTECTED]