Re: postgres_fdw and skip locked - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: postgres_fdw and skip locked
Date
Msg-id CAExHW5t1ua3yeKu8D04UZQzApMR4zYOi4AkkENygsqhmNaaMFA@mail.gmail.com
Whole thread Raw
In response to postgres_fdw and skip locked  (Alexander Pyhalov <a.pyhalov@postgrespro.ru>)
Responses Re: postgres_fdw and skip locked
List pgsql-hackers
On Mon, Feb 14, 2022 at 4:23 PM Alexander Pyhalov
<a.pyhalov@postgrespro.ru> wrote:
>
> Hi.
>
> Now select ... for update ... [skip locked|nowait] options are not
> pushed down to remote servers. I see the only reason is that we can
> speak to pre-9.5 server, which doesn't understand skip locked option.
> Are there any other possible issues? Should we add foreign table option
> to control this behavior?

Should we always push these clauses if remote server's version is
newer than 9.5? There are quite a few options already. It will be good
not to add one more.

I see that these options will work for all kinds of relations. So no
problem if foreign table is pointing to something other than a table.

-- 
Best Wishes,
Ashutosh Bapat



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgsql: Move scanint8() to numutils.c
Next
From: Robert Haas
Date:
Subject: Re: some aspects of our qsort might not be ideal