Hi,
I have a table with events that must be handled by multiple clients. It
does not matter which client handles an event, but no two clients may
handle the same event and an event may only handled once. A client can
only determine the availability of an event by querying the database.
The
Joost Kraaijeveld [EMAIL PROTECTED] writes:
I have read the manual about LOCK, SET TRANSACTION and SELECT...FOR
UPDATE, but from what I understand, they cannot prevent a SELECT from
another client, based on the SELECT.
Is there a way to make this possible?
Have all the clients use SELECT
On Mon, 2006-07-03 at 07:54 -0400, Douglas McNaught wrote:
Have all the clients use SELECT FOR UPDATE.
OK, thanks, your answer lead me to a re-read of the docs and I think I
found a way to do it.
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063