Re: pyPgSql there is already a transaction in progres

2009-06-02 Thread Paul Boddie
On 2 Jun, 16:49, Tep wrote: > On Jun 2, 3:58 pm, Paul Boddie wrote: > > Really, you should use the commit method on the cursor object > > You mean connection object, do you? Yes, I meant the connection object. :-) > I've tried that, but forgotten to remove BEGIN;COMMIT; statements from > my que

Re: pyPgSql there is already a transaction in progres

2009-06-02 Thread Tep
On Jun 2, 3:58 pm, Paul Boddie wrote: > On 2 Jun, 15:32, someone wrote: > > > Hi, > > I'm using pyPgSQL for accessing Postgres and do some update and select > > queries. > > and getting WARNING:  there is already a transaction in progress if I > > run runUpdate more than once. > > I think this is

Re: pyPgSql there is already a transaction in progres

2009-06-02 Thread Paul Boddie
On 2 Jun, 15:32, someone wrote: > Hi, > I'm using pyPgSQL for accessing Postgres and do some update and select > queries. > and getting WARNING:  there is already a transaction in progress if I > run runUpdate more than once. I think this is because you're using explicit transaction statements am