Re: Fix FK deadlock, but no magic please

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jon Swinth <jswinth(at)atomicpc(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fix FK deadlock, but no magic please
Date: 2003-01-17 18:09:36
Message-ID: 20030117100907.I24247-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simeó Reig 2003-01-17 18:30:34 SQL HELP
Previous Message Patrick Nelson 2003-01-17 17:31:57 Re: Upgrading