pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Problems with Transactions
2+ messages / 2 participants
[nested] [flat]

* Problems with Transactions
@ 2003-02-11 13:29 Héctor Iturre <hhiturre@yahoo.com.ar>
  0 siblings, 0 replies; 2+ messages in thread

From: Héctor Iturre @ 2003-02-11 13:29 UTC (permalink / raw)
  To: pgsql-sql

Hi,
   I'm using Postgres 7.2 and i'm having problems with
transactions. Is there a function or table that
informs which user is blocking a row? 
   
   Thanks for all 

                       Kbza

Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Problems with Transactions
@ 2003-02-12 14:18 Christoph Haller <ch@rodos.fzk.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Christoph Haller @ 2003-02-12 14:18 UTC (permalink / raw)
  To: pgsql-sql; +Cc: hhiturre@yahoo.com.ar

>
> I'm using Postgres 7.2 and i'm having problems with
> transactions. Is there a function or table that
> informs which user is blocking a row?
>
AFAIK, there is no such information available.
Are your problems with transactions coming from
blocked rows?

Maybe this 7.3 feature can help you

>
> PostgreSQL 7.3 Documentation
> 3.4. Run-time Configuration
> STATEMENT_TIMEOUT (integer)
> Aborts any statement that takes over the specified number of
milliseconds. A value of zero turns off the timer.
> DEADLOCK_TIMEOUT (integer)
> This is the amount of time, in milliseconds, to wait on a lock before
checking to see if there is a deadlock condition
>
Regards, Christoph





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-02-12 14:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-11 13:29 Problems with Transactions Héctor Iturre <hhiturre@yahoo.com.ar>
2003-02-12 14:18 Re: Problems with Transactions Christoph Haller <ch@rodos.fzk.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox