Re: postgres timeout.

From: Stef <svb(at)ucs(dot)co(dot)za>
To: pg-perform <pgsql-performance(at)postgresql(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org <pgsql-sql(at)postgresql(dot)org>
Subject: Re: postgres timeout.
Date: 2004-01-28 10:12:17
Message-ID: 20040128121217.2e4aceef.svb@ucs.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-sql

Forgot to mention that I use postgres 7.3.4

Stef mentioned :
=> Hi all ,
=>
=> I'm trying to find out if there is a specific setting
=> to make transactions time out faster in a scenario
=> where there's an update on a table in a transaction
=> block, and another update process tries to update
=> the same column.
=>
=> It looks like the second process will wait until you
=> end the transaction block in the first transaction.
=>
=> I've looked at the deadlock timeout parameter and
=> other parameters, but I don't think I found what
=> I'm looking for.
=>
=> I basically need to be able to let the second process
=> exit with an error after waiting 5 - 10 seconds.
=>
=> Please can someone help?
=>
=> Kind Regards
=> Stefan
=>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stef 2004-01-28 10:47:22 Re: postgres timeout. [SOLVED]
Previous Message Stef 2004-01-28 10:11:09 postgres timeout.

Browse pgsql-sql by date

  From Date Subject
Next Message raingsey 2004-01-28 10:12:19 Help! Error with postgresql!
Previous Message Stef 2004-01-28 10:11:09 postgres timeout.