Re: [GENERAL] queston about locking

2007-09-21 Thread Martijn van Oosterhout
On Fri, Sep 21, 2007 at 11:53:54AM +0200, Ottavio Campana wrote: > the point is that for each table I have a copy I previously made and I > want to create an incremental backup. My problem is that I don't want > the original table to change, so I lock it. > > I admin that exclusive lock is probabl

Re: [GENERAL] queston about locking

2007-09-21 Thread Ottavio Campana
Albe Laurenz ha scritto: > Ottavio Campana wrote: >> I'm writing a python script to update some tables in a db. My >> problem is >> that I need to lock a couple of tables, perform several operations and >> read the corresponding output. >> >> I was thinking about lock in exclusive mode, but in the

Re: [GENERAL] queston about locking

2007-09-21 Thread Albe Laurenz
Ottavio Campana wrote: > I'm writing a python script to update some tables in a db. My > problem is > that I need to lock a couple of tables, perform several operations and > read the corresponding output. > > I was thinking about lock in exclusive mode, but in the > documentation I > found that

[GENERAL] queston about locking

2007-09-21 Thread Ottavio Campana
I'm writing a python script to update some tables in a db. My problem is that I need to lock a couple of tables, perform several operations and read the corresponding output. I was thinking about lock in exclusive mode, but in the documentation I found that it is valid only in a transaction. But s