Re: doc: CREATE FOREIGN TABLE .. PARTITION OF .. DEFAULT
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Jeevan Ladhe <jeevanladhe.os@gmail.com>
Date: 2022-05-25T12:44:23Z
Lists: pgsql-hackers
On Sat, May 21, 2022 at 9:09 AM Justin Pryzby <pryzby@telsasoft.com> wrote:
> It looks like the docs weren't updated in 6f6b99d13 for v11.
In my defense, that commit definitely contained documentation changes.
It updated alter_table.sgml and create_table.sgml. I guess we missed
create_foreign_table.sgml, though.
> The docs also seem to omit "FOR VALUES" literal.
> And don't define partition_bound_spec (which I didn't fix here).
>
> diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml
> index b374d8645db..1f1c4a52a2a 100644
> --- a/doc/src/sgml/ref/create_foreign_table.sgml
> +++ b/doc/src/sgml/ref/create_foreign_table.sgml
> @@ -35,7 +35,8 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] <replaceable class="parameter">table_name
> { <replaceable class="parameter">column_name</replaceable> [ WITH OPTIONS ] [ <replaceable class="parameter">column_constraint</replaceable> [ ... ] ]
> | <replaceable>table_constraint</replaceable> }
> [, ... ]
> -) ] <replaceable class="parameter">partition_bound_spec</replaceable>
> +) ]
> + { FOR VALUES <replaceable class="parameter">partition_bound_spec</replaceable> | DEFAULT }
> SERVER <replaceable class="parameter">server_name</replaceable>
> [ OPTIONS ( <replaceable class="parameter">option</replaceable> '<replaceable class="parameter">value</replaceable>' [, ... ] ) ]
OK, makes sense. I guess we need to copy over the definition of
partition_bound_spec from create_table.sgml here as well.
--
Robert Haas
EDB: http://www.enterprisedb.com
Commits
-
Doc: Further fix CREATE FOREIGN TABLE synopsis.
- cc75ad780d53 11.17 landed
- dadee8753936 12.12 landed
- de61a9cbaa95 13.8 landed
- 18e3b197bc6a 14.4 landed
- 642e9165fd51 15.0 landed
-
In CREATE FOREIGN TABLE syntax synopsis, fix partitioning stuff.
- d605eba0904b 10.22 landed
- 0fab33916789 11.17 landed
- 4368ef218959 12.12 landed
- 036cffbcae9b 13.8 landed
- a5fc06bf3135 14.4 landed
- ce21a36cf837 15.0 landed