| From: | Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | postgres_fdw and skip locked |
| Date: | 2022-02-14 10:53:35 |
| Message-ID: | 98951cc482cabdd6a2bc25e810392dca@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
--
Best regards,
Alexander Pyhalov,
Postgres Professional
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-postgres_fdw-could-pass-lock-wait-policy-to-foreign-.patch | text/x-diff | 11.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frédéric Yhuel | 2022-02-14 10:56:44 | Re: Allow parallel plan for referential integrity checks? |
| Previous Message | tanghy.fnst@fujitsu.com | 2022-02-14 10:30:19 | RE: row filtering for logical replication |