On Wed, Aug 7, 2024 at 9:32 PM Fujii Masao <masao.fu...@oss.nttdata.com> wrote: > However, when using PostgreSQL 9.4 or earlier as a remote server, > INSERT ON CONFLICT on a foreign table fails because this feature > is only supported in v9.5 and later. Should we add a note to > the documentation to clarify this limitation?
+1 > For example: > "Another limitation is that when executing INSERT statements with > an ON CONFLICT DO NOTHING clause on a foreign table, the remote server > must be running PostgreSQL 9.5 or later, as earlier versions do not > support this feature." We already have this note in the documentation: “Note that postgres_fdw currently lacks support for INSERT statements with an ON CONFLICT DO UPDATE clause. However, the ON CONFLICT DO NOTHING clause is supported, provided a unique index inference specification is omitted.” So yet another idea is to expand the latter part a little bit like: However, the ON CONFLICT DO NOTHING clause is supported, provided a unique index inference specification is omitted and the remote server is 9.5 or later. I just thought consolidating the information to one place would make the documentation more readable. Best regards, Etsuro Fujita
