Re: Is what I want possible and if so how? - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Is what I want possible and if so how?
Date
Msg-id 87irmej43z.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Is what I want possible and if so how?  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: Is what I want possible and if so how?  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-general
Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> 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 FOR UPDATE.

-Doug

pgsql-general by date:

Previous
From: David Hoksza
Date:
Subject: query execution time
Next
From: Dragan Matic
Date:
Subject: Re: different sort order in windows and linux version