Ian West <ian@niw.com.au> writes:
> Is there any way to request postgres to immediately fail, or better yet
> fail after some small time when trying to obtain a conflicting lock ?
Deadlocks should be detected within about a second. If you have an
example where one is not, let's see it...
regards, tom lane