Re: Locking and postgres_fdw extension

2020-11-19 Thread Tom Lane
Steve Baldwin 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

Locking and postgres_fdw extension

2020-11-19 Thread Steve Baldwin
Hi all, I have two DB instances - 'online' and 'offline'. In 'offline' I have a foreign table 'f' imported from 'online'. I want to execute a query from 'offline' to obtain a row lock, and this works fine: select id from f where id = 1 for no key update; However if I want it to fail immediately