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 if unable to obtain the lock, it seems nowait is ignored for foreign tables (or at least with my version of postgres_fdw). The waiting session blocks until the holding session commits or rolls back.
My 'workaround' was to create a view in 'online':
create or replace view f_lock as select * from f for no key update nowait;
Then use import foreign schema to bring that view into 'offline'. I can then execute:
select id from f_lock where id = 1;
and it will fail immediately if the row is already locked.
Is there a better way to do this?
Thanks,
Steve
