From: Shinoda, Noriyoshi (PSD Japan FSI) <noriyoshi.shinoda@hpe.com>
To: Jeff Davis <pgsql@j-davis.com>
To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Shlok Kyal <shlok.kyal.oss@gmail.com>
Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Cc: Joe Conway <mail@joeconway.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: RE: [19] CREATE SUBSCRIPTION ... SERVER
Date: Fri, 10 Apr 2026 02:00:58 +0000
Message-ID: <LV8PR84MB3787135EBDBF7747A05731F3EE592@LV8PR84MB3787.NAMPRD84.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <fd49b44dc65da8e71ab20c1cf1ec7e65921c20f5.camel@j-davis.com>
References: <7eb0c03b4312b32cb76d340023b39a751745a1f9.camel@j-davis.com>
<fd49b44dc65da8e71ab20c1cf1ec7e65921c20f5.camel@j-davis.com>
Hi,
Thanks for developing this great feature.
> Committed two patches.
The commit of 0004 patch added the `fdwconnection` column to the pg_foreign_data_wrapper catalog.
However, it seems the documentation is missing the definition for this column. The small patch attached adds the information for this column to catalog.sgml. There might be a better phrasing for the description text.
Regards,
Noriyoshi Shinoda
-----Original Message-----
From: Jeff Davis <pgsql@j-davis.com>
Sent: Thursday, March 19, 2026 4:07 AM
To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>; Masahiko Sawada <sawada.mshk@gmail.com>; Shlok Kyal <shlok.kyal.oss@gmail.com>; Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>; Joe Conway <mail@joeconway.com>; pgsql-hackers@postgresql.org
Subject: Re: [19] CREATE SUBSCRIPTION ... SERVER
On Sat, 2026-03-14 at 15:55 -0700, Jeff Davis wrote:
> Attached series including patches to address Andres's and Amit's
> comments, too.
Committed two patches.
New patch 0004: fixes missing dependencies from the FDW to the connection function. There's a related pre-existing issue with the dependency from the FDW to the handler function, which I will post as a separate backportable bugfix.
I'd still like to find a good way to add pg_dump tests. The only idea I have now is to build the test function into core postgres (without pg_proc entry), which might be worthwhile.
Regards,
Jeff Davis
Attachments:pg_foreign_data_wrapper_doc_v1.diff (application/octet-stream, 941B) downloaddiff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgmlindex 0b3e6308d56..58d4db7e957 100644--- a/doc/src/sgml/catalogs.sgml+++ b/doc/src/sgml/catalogs.sgml@@ -4181,6 +4181,17 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l
</para></entry>
</row>
+ <row>+ <entry role="catalog_table_entry"><para role="column_definition">+ <structfield>fdwconnection</structfield> <type>oid</type>+ (references <link linkend="catalog-pg-proc"><structname>pg_proc</structname></link>.<structfield>oid</structfield>)+ </para>+ <para>+ References a connection function that is responsible for+ providing the connection string for the foreign-data wrapper+ </para></entry>+ </row>+
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>fdwacl</structfield> <type>aclitem[]</type>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: noriyoshi.shinoda@hpe.com, pgsql@j-davis.com, ashutosh.bapat.oss@gmail.com, amit.kapila16@gmail.com, sawada.mshk@gmail.com, shlok.kyal.oss@gmail.com, bharath.rupireddyforpostgres@gmail.com, mail@joeconway.com
Subject: RE: [19] CREATE SUBSCRIPTION ... SERVER
In-Reply-To: <LV8PR84MB3787135EBDBF7747A05731F3EE592@LV8PR84MB3787.NAMPRD84.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox