Message-ID: <8c0db5db939a71dea0c9307207aa0842f84c352c.camel@j-davis.com>
Subject: Re: [17] CREATE SUBSCRIPTION ... SERVER
From: Jeff Davis <pgsql@j-davis.com>
To: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Cc: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Joe Conway
	 <mail@joeconway.com>, pgsql-hackers@postgresql.org
Date: Wed, 17 Jan 2024 23:17:01 -0800
In-Reply-To: 
 <CALj2ACXw81_Cv36qL+twaLjX1_L59CctufKbYdvm9pyC_9GsWQ@mail.gmail.com>
References: <149ff9264db27cdf724b65709fbbaee4bf316835.camel@j-davis.com>
	 <CAExHW5vv-78ixJs3arsuZ+12A4AyqehJnDPhejp0m4FAKG6JZA@mail.gmail.com>
	 <830a2bc6cbbb2e6e01c6c0d9f31f320822e10603.camel@j-davis.com>
	 <CAExHW5sAo4Gv3AwuxQNGSQ2Z45B8_MZEb-SG-B8D-hLMdrquAg@mail.gmail.com>
	 <e531ec798298a21d671babd45849092850b8675e.camel@j-davis.com>
	 <ac4042d6-204c-9661-9949-79ab8a1f8604@joeconway.com>
	 <CAExHW5unvpDv6yMSmqurHP7Du1PqoJFWVxeK-4YNm5EnoNJiSQ@mail.gmail.com>
	 <433d0845248e86c0317d9d396926182cfe157340.camel@j-davis.com>
	 <CAExHW5sQVJeCgCGMkum_k4Z4VPaK5GkdAjHW-d+F3MngBZ9qBA@mail.gmail.com>
	 <05ae37abb207cd6bf6b126780024692d91402b0b.camel@j-davis.com>
	 <93392ffa941ab0d436e19e0ab5d04d0e42c02d3f.camel@j-davis.com>
	 <26be917cb07b6aa3ef5dd15f6b59d1b375ece6e8.camel@j-davis.com>
	 <CALj2ACXDua2Az15Kj3OZFaRm49G8-faemiEEv8t9GNCcsxv8Hw@mail.gmail.com>
	 <55201bd916e748acfc754c8f95880dae8e4e5ed0.camel@j-davis.com>
	 <CAExHW5v5poohyfNRVQp3yjVE56ej0dWvVMbysSSVtg21aHT3uQ@mail.gmail.com>
	 <e71e029309171eb8b6ca393306f9bc5acfbfdf8f.camel@j-davis.com>
	 <CAExHW5vF+cp9efQj=-W+Rhbr9f9ZZqt3XFnP0NB5jKsm=C=5tw@mail.gmail.com>
	 <2a89b14a2b1622bffb8b137ca1f9ab7866f2d2b9.camel@j-davis.com>
	 <61831790a0a937038f78ce09f8dd4cef7de7456a.camel@j-davis.com>
	 <CALj2ACXw81_Cv36qL+twaLjX1_L59CctufKbYdvm9pyC_9GsWQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu2 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/8c0db5db939a71dea0c9307207aa0842f84c352c.camel%40j-davis.com>
Precedence: bulk

On Tue, 2024-01-16 at 09:23 +0530, Bharath Rupireddy wrote:
> 1.
>  May be a more descriptive note is
> worth here instead of just saying "Load the library providing us
> libpq calls."?

OK, will be in the next patch set.

> 2. Why not typedef keyword before the ConnectionOption structure?

Agreed. An earlier unpublished iteration had the struct more localized,
but here it makes more sense to be typedef'd.

> 3.
> +static const struct ConnectionOption *
> +libpqrcv_conninfo_options(void)
>=20
> Why is libpqrcv_conninfo_options returning the const
> ConnectionOption?

I did that so I could save the result, and each subsequent call would
be free (just returning the same pointer). That also means that the
caller doesn't need to free the result, which would require another
entry point in the API.

> Is it that we don't expect callers to modify the result? I think it's
> not needed given the fact that PQconndefaults doesn't constify the
> return value.

The result of PQconndefaults() can change from call to call when the
defaults change. libpqrcv_conninfo_options() only depends on the
available option names (and dispchar), which should be a static list.

> 4.
> +=C2=A0=C2=A0=C2=A0 /* skip options that must be overridden */
> +=C2=A0=C2=A0=C2=A0 if (strcmp(option, "client_encoding") =3D=3D 0)
> +=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return false;
> +
>=20
> Options that must be overriden or disallow specifiing
> "client_encoding" in the SERVER/USER MAPPING definition (just like
> the
> dblink)?

I'm not quite sure of your question, but I'll try to improve the
comment.

> 5.
> "By using the correct libpq options, it no longer needs to be
> deprecated, and can be used by the upcoming pg_connection_fdw."
>=20
> Use of postgresql_fdw_validator for pg_connection_fdw seems a bit odd
> to me. I don't mind pg_connection_fdw having its own validator
> pg_connection_fdw_validator even if it duplicates the code. To avoid
> code duplication we can move the guts to an internal function in
> foreign.c so that both postgresql_fdw_validator and
> pg_connection_fdw_validator can use it. This way the code is cleaner
> and we can just leave postgresql_fdw_validator as deprecated.

Will do so in the next patch set.

Thank you for taking a look.

Regards,
	Jeff Davis