Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commite52e271

Browse files
doc: Fix syntax in ALTER FOREIGN DATA WRAPPER example
The example for dropping an option was incorrectly quoting theoption key thus making it a value turning the command into anunqualified ADD operation. The result of dropping became addinga 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 allsupported branches.Author: Tim <tim.needham2@gmail.com>Discussion:https://postgr.es/m/170292280173.1876505.5204623074024041738@wrigleys.postgresql.org
1 parent3c080fb commite52e271

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

‎doc/src/sgml/ref/alter_foreign_data_wrapper.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -153,7 +153,7 @@ ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> REN
153153
Change a foreign-data wrapper <literal>dbi</literal>, add
154154
option <literal>foo</literal>, drop <literal>bar</literal>:
155155
<programlisting>
156-
ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP'bar');
156+
ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP bar);
157157
</programlisting>
158158
</para>
159159

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp