Horton

Fix inaccurate mention of index comments in CREATE FOREIGN TABLE docs

Fujii Masao <masao.fujii@oss.nttdata.com>

View thread View on postgr.es
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: pgsql-docs@lists.postgresql.org
Date: 2025-06-18T05:34:55Z
Lists: pgsql-docs

Attachments

Hi,

Commit 302cf157592 added support for LIKE in CREATE FOREIGN TABLE.
In this feature, since indexes are not created for foreign tables,
comments on indexes are not copied either.

However, the CREATE FOREIGN TABLE docs incorrectly states that
index comments are copied when using INCLUDING COMMENTS, as shown below:

     ------------------------------
     INCLUDING COMMENTS
     Comments for the copied columns, constraints, and indexes will be copied.
     ------------------------------

This isn't accurate for foreign tables, so we should remove the mention
of indexes. Patch attached.

Regards,

-- 
Fujii Masao
NTT DATA Japan Corporation

Commits

  1. doc: Fix incorrect description of INCLUDING COMMENTS in CREATE FOREIGN TABLE.

  2. Add support for LIKE in CREATE FOREIGN TABLE