Re: timeout on lock feature - Mailing list pgsql-hackers

From Tom Lane
Subject Re: timeout on lock feature
Date
Msg-id 4547.987180295@sss.pgh.pa.us
Whole thread Raw
In response to Re: timeout on lock feature  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: timeout on lock feature  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I can imagine some people wanting this.  However, 7.1 has new deadlock
> detection code, so I would you make a 7.1 version and send it over.  We
> can get it into 7.2.

I object strongly to any such "feature" in the low-level form that
Henryk proposes, because it would affect *ALL* locking.  Do you really
want all your other transactions to go belly-up if, say, someone vacuums
pg_class?

A variant of LOCK TABLE that explicitly requests a timeout might make
sense, though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Yellow Dog Linux/PPC regression
Next
From: Tom Lane
Date:
Subject: Re: Re: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can't import to v7.1?