Steve Baldwin <steve.baldwin@gmail.com> writes:
> However if I want it to fail immediately if unable to obtain the lock, it
> seems nowait is ignored for foreign tables (or at least with my version of
> postgres_fdw).
Hmm ... this seems to be intentional, per the comments in
deparseLockingClause():
* For now, just ignore any [NO] KEY specification, since (a)
* it's not clear what that means for a remote table that we
* don't have complete information about, and (b) it wouldn't
* work anyway on older remote servers. Likewise, we don't
* worry about NOWAIT.
However, it's not super clear whether the concern about NOWAIT is just
that the remote server might be too old to know that keyword, or
whether there's some deeper issue.
(I see your example is also falling foul of the non-implementation
of NO KEY, which might be confusing matters still more.)
regards, tom lane