Re: Is what I want possible and if so how?

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is what I want possible and if so how?
Date: 2006-07-03 11:54:24
Message-ID: 87irmej43z.fsf@suzuka.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dragan Matic 2006-07-03 11:58:34 Re: different sort order in windows and linux version
Previous Message David Hoksza 2006-07-03 10:53:53 query execution time

Browse pgsql-jdbc by date

  From Date Subject
Next Message Joost Kraaijeveld 2006-07-03 13:34:46 Re: Is what I want possible and if so how?
Previous Message Joost Kraaijeveld 2006-07-03 10:45:45 Is what I want possible and if so how?