Re: row-level locking bug?

rkusenet wrote: > > have you created necessary indices in the table. Without them, > the engine will be forced to do a sequential scan. if isolation > level requries locking all rows during inspection, you will get > the error you are seeing. Even with dirty read, a sequentially scanning update will trip over a lock. I've written about this several times; do a google search for promotable lock in articles written by me.