Postgres Pro
Downloads
Home   >   mailing lists

Re: select for update with left outer joins? - Mailing list pgsql-general

From Tom Lane
Subject Re: select for update with left outer joins?
Date
Msg-id 27406.1041696558@sss.pgh.pa.us
Whole thread Raw
In response to select for update with left outer joins?  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Responses Re: select for update with left outer joins?
List pgsql-general
Tree view 
Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> Is it expected that select for update doesn't work with left outer joins?

What would you consider the semantics to be?  I am not sure how to lock
the absence of a matching row ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Boget, Chris"
Date:
Subject: Constraints/On Delete...
Next
From: Stephan Szabo
Date:
Subject: Re: Constraints/On Delete...