aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorDaniel Gustafsson <dgustafsson@postgresql.org>2023-12-19 14:13:50 +0100
committerDaniel Gustafsson <dgustafsson@postgresql.org>2023-12-19 14:13:50 +0100
commite52e271b23005f27e997215617993c87629247f2 (patch)
treee3c737ba26548f7632a905219e673e9639f7e052 /doc/src
parent3c080fb4fad3e1c1e34f74a7b84a443137adc9f2 (diff)
downloadpostgresql-e52e271b23005f27e997215617993c87629247f2.tar.gz
postgresql-e52e271b23005f27e997215617993c87629247f2.zip
doc: Fix syntax in ALTER FOREIGN DATA WRAPPER example
The example for dropping an option was incorrectly quoting the option key thus making it a value turning the command into an unqualified ADD operation. The result of dropping became adding a new key/value pair instead: d=# alter foreign data wrapper f options (drop 'b'); ALTER FOREIGN DATA WRAPPER d=# select fdwoptions from pg_foreign_data_wrapper where fdwname='f'; fdwoptions ------------ {drop=b} (1 row) This has been incorrect for a long time so backpatch to all supported branches. Author: Tim <tim.needham2@gmail.com> Discussion: https://postgr.es/m/170292280173.1876505.5204623074024041738@wrigleys.postgresql.org
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/alter_foreign_data_wrapper.sgml2
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml
index 54f34c2c015..dc0957d965a 100644
--- a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml
+++ b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml
@@ -153,7 +153,7 @@ ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> REN
Change a foreign-data wrapper <literal>dbi</literal>, add
option <literal>foo</literal>, drop <literal>bar</literal>:
<programlisting>
-ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP 'bar');
+ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP bar);
</programlisting>
</para>