BUG #1390: Lock Timeout

From: "Tristen Ennemuist" <tristen(at)mangolist(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1390: Lock Timeout
Date: 2005-01-12 13:23:59
Message-ID: 200501121323.j0CDNxi5000679@developer.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1390
Logged by: Tristen Ennemuist
Email address: tristen(at)mangolist(dot)com
PostgreSQL version: 7.4
Operating system: linux
Description: Lock Timeout
Details:

This is more of an enhancement request, not a bug.

It would be nice if a lock timeout was implemented.

Currently postgresql causes a process to wait indefinitely until the record
becomes available.

I suppose there are many arguments for and against lock timeouts - but if it
were configurable, then developers could have the luxury of choice.

It would therefore be ideal if a LOCK_TIMEOUT (or similar) parameter (in
milliseconds) could be added to the conf file. A default zero value could
indicate the current indefinite behaviour.

Great product, keep up the good work. I'm currently migrating from MySQL and
this is the one and only explicit functionality compromise I've had to
make.

Can't wait for version 8!

Best regards
Tristen

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pailloncy Jean-Gerard 2005-01-12 13:34:21 8rc5 on OpenBSD
Previous Message John Hansen 2005-01-12 12:38:38 Re: RULES doesn't work as expected