Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: Kurt Roeckx <Q@ping.be>, pgsql-sql@postgresql.org
Subject: Re: Selecting a non-locked row.
Date: Sun, 19 Jan 2003 13:26:10 -0800
References: <20030119133320.GA3984@ping.be>
In-Reply-To: <20030119133320.GA3984@ping.be>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200301191326.10285.josh@agliodbs.com>

Kurt,

> I'm in the process of writing an application, and I'm not sure
> how to properly solve it.
>=20
> I have a table with records in, and they either still need to be
> processed or not.  Several people will be using the table at the
> same time.
>=20
> I was thinking about using a select .... for update limit 1, but
> the other persons will of course try to select the same record
> and wait until that one is released.  The locks are held for a
> long period of time.
>=20
> Is there a way to select a row that is not locked yet?

I'm a bit confused by your question.  Could you try explaining it another w=
ay,=20
possibly with SQL code examples?


--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco