| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | hhiturre(at)yahoo(dot)com(dot)ar |
| Subject: | Re: Problems with Transactions |
| Date: | 2003-02-12 14:18:38 |
| Message-ID: | 3E4A57BE.B3A1CC87@rodos.fzk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Plant Thomas | 2003-02-12 14:37:07 | Sum of Intervals |
| Previous Message | Christoph Haller | 2003-02-12 13:48:58 | Re: PL/Pgsql trigger function problem. |