Commite28a271

committed

doc: mention of postpostgres_fdw INSERT ON CONFLICT limitation

Reported-by: Fujii MasaoDiscussion:https://postgr.es/m/47801526-d017-4c89-9f52-c02c449a139b@oss.nttdata.comAuthor: Fujii MasaoBackpatch-through: master

1 parentcf3bb26 commite28a271Copy full SHA for e28a271

File tree

+11

-1

lines changed

+11

-1

lines changed

Lines changed: 11 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1096,7 +1096,10 @@ postgres=# SELECT postgres_fdw_disconnect_all();`
`1096`	`1096`	`<para>`
`1097`	`1097`	`<filename>postgres_fdw</filename> can be used with remote servers dating back`
`1098`	`1098`	`to <productname>PostgreSQL</productname> 8.3. Read-only capability is available`
`1099`		`- back to 8.1. A limitation however is that <filename>postgres_fdw</filename>`
	`1099`	`+ back to 8.1.`
	`1100`	`+ </para>`
	`1101`	`+ <para>`
	`1102`	`+ A limitation however is that <filename>postgres_fdw</filename>`
`1100`	`1103`	`generally assumes that immutable built-in functions and operators are`
`1101`	`1104`	`safe to send to the remote server for execution, if they appear in a`
`1102`	`1105`	`<literal>WHERE</literal> clause for a foreign table. Thus, a built-in`
`@@ -1108,6 +1111,13 @@ postgres=# SELECT postgres_fdw_disconnect_all();`
`1108`	`1111`	`optimization fence, and placing the problematic function or operator`
`1109`	`1112`	`outside the sub-<literal>SELECT</literal>.`
`1110`	`1113`	`</para>`
	`1114`	`+ <para>`
	`1115`	`+ Another limitation is that when executing <command>INSERT</command>`
	`1116`	`+ statements with an <literal>ON CONFLICT DO NOTHING</literal> clause on`
	`1117`	`+ a foreign table, the remote server must be running`
	`1118`	`+ <productname>PostgreSQL</productname> 9.5 or later,`
	`1119`	`+ as earlier versions do not support this feature.`
	`1120`	`+ </para>`
`1111`	`1121`	`</sect2>`
`1112`	`1122`
`1113`	`1123`	`<sect2 id="postgres-fdw-wait-events">`

Comments

(0)