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: 200501121323.j0CDNxi5000679@developer.pgadmin.org (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group