On 29/12/2009 20:59, Leonardo M. Ramé wrote:
> in " in transaction". The interesting thing is the app is doing
> only Selects, without opening transactions.
Everything in PG happens in a transaction, whether you open one
explicitly or not.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@i
2009/12/29 Leonardo M. :
> El mar, 29-12-2009 a las 15:44 -0500, Merlin Moncure escribió:
>> right. IIRC the zeos library has a transaction mode that controls if
>> commits are explicit or invoked via the library commit method. either
>> way, you you need to make sure that transactions are not lef
El mar, 29-12-2009 a las 15:44 -0500, Merlin Moncure escribió:
> right. IIRC the zeos library has a transaction mode that controls if
> commits are explicit or invoked via the library commit method. either
> way, you you need to make sure that transactions are not left
> open...this can lead (as y
2009/12/29 Leonardo M. :
> El mar, 29-12-2009 a las 15:05 -0500, Merlin Moncure escribió:
>> > This solves the locking problem, but what happens to transactions? the
>> > app is still working in transaction mode, or just applying changes after
>> > every Insert/Update/Delete?.
>>
>> huh...the defau
El mar, 29-12-2009 a las 15:05 -0500, Merlin Moncure escribió:
> > This solves the locking problem, but what happens to transactions? the
> > app is still working in transaction mode, or just applying changes after
> > every Insert/Update/Delete?.
>
> huh...the default transaction mode _is_ read c
2009/12/29 Leonardo M. :
> El mar, 29-12-2009 a las 14:18 -0500, Merlin Moncure escribió:
>> >>
>> >
>> > Well, I'm trying to debug the problem, and found that when I do a simple
>> > "select * from table" from my app, then go to pgAdmin, and do "select *
>> > from pg_locks", it shows many locks (2
El mar, 29-12-2009 a las 14:18 -0500, Merlin Moncure escribió:
> >>
> >
> > Well, I'm trying to debug the problem, and found that when I do a simple
> > "select * from table" from my app, then go to pgAdmin, and do "select *
> > from pg_locks", it shows many locks (23 to be exact).
>
> Those locks
2009/12/29 Leonardo M. :
> El mar, 29-12-2009 a las 14:48 -0300, Leonardo M. Ramé escribió:
>> El mar, 29-12-2009 a las 11:20 -0500, Bill Moran escribió:
>> > In response to "Leonardo M." Ramé :
>> >
>> > > Hi, I need to create a trigger on a table used by our sofware, the
>> > > problem is, when I
El mar, 29-12-2009 a las 14:48 -0300, Leonardo M. Ramé escribió:
> El mar, 29-12-2009 a las 11:20 -0500, Bill Moran escribió:
> > In response to "Leonardo M." Ramé :
> >
> > > Hi, I need to create a trigger on a table used by our sofware, the
> > > problem is, when I issue a "create trigger" o
El mar, 29-12-2009 a las 11:20 -0500, Bill Moran escribió:
> In response to "Leonardo M." Ramé :
>
> > Hi, I need to create a trigger on a table used by our sofware, the
> > problem is, when I issue a "create trigger" on this table, it takes
> > forever. It doesn't matter if I use pgAdmin, or
In response to "Leonardo M." Ramé :
> Hi, I need to create a trigger on a table used by our sofware, the
> problem is, when I issue a "create trigger" on this table, it takes
> forever. It doesn't matter if I use pgAdmin, or psql.
>
> The only way to do it is by disconnecting all the instance
11 matches
Mail list logo
