Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

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

Can't wait for version 8!

Best regards


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group