Re: Fix FK deadlock, but no magic please - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Fix FK deadlock, but no magic please
Date
Msg-id 20030117100907.I24247-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Fix FK deadlock, but no magic please  (Jon Swinth <jswinth@atomicpc.com>)
Responses Re: Fix FK deadlock, but no magic please
List pgsql-general
On Fri, 17 Jan 2003, Jon Swinth wrote:

> Now, if we could only have the feature like Oracle of SELECT  ... FOR UPDATE
> NOWAIT, so I can control how long we wait for a lock.  Wait... can't do that
> until SQL exceptions stop voiding the transaction (I want to be able to retry
> the lock several times before giving up).

What's Oracle's behavior when some of the rows can be locked and some
can't?


pgsql-general by date:

Previous
From: Patrick Nelson
Date:
Subject: Re: Upgrading
Next
From: Simeó Reig
Date:
Subject: SQL HELP