Re: Cross-version Compatibility of postgres_fdw

2024-08-27 Thread Etsuro Fujita
On Tue, Aug 20, 2024 at 8:55 AM Bruce Momjian wrote: > I think it is an improvement, so applied to master. Thanks. Thanks for taking care of this! Best regards, Etsuro Fujita

Re: Cross-version Compatibility of postgres_fdw

2024-08-19 Thread Bruce Momjian
On Wed, Aug 14, 2024 at 03:25:48AM +0900, Etsuro Fujita wrote: > On Tue, Aug 13, 2024 at 12:15 PM Fujii Masao > wrote: > > On 2024/08/09 17:49, Etsuro Fujita wrote: > > > I just thought consolidating the information to one place would make > > > the documentation more readable. > > > > Yes, so I t

Re: Cross-version Compatibility of postgres_fdw

2024-08-13 Thread Etsuro Fujita
On Tue, Aug 13, 2024 at 12:49 PM Tom Lane wrote: > This discussion tickles a concern I've had for awhile: do we really > know that modern postgres_fdw would work with an 8.3 server (never > mind 8.1)? How many of us are in a position to test or debug such > a setup? The discussions we've had aro

Re: Cross-version Compatibility of postgres_fdw

2024-08-13 Thread Etsuro Fujita
On Tue, Aug 13, 2024 at 12:15 PM Fujii Masao wrote: > On 2024/08/09 17:49, Etsuro Fujita wrote: > > I just thought consolidating the information to one place would make > > the documentation more readable. > > Yes, so I think that adding a note about the required remote server version > to the cro

Re: Cross-version Compatibility of postgres_fdw

2024-08-12 Thread Tom Lane
Fujii Masao writes: > Yes, so I think that adding a note about the required remote server version > to the cross-version compatibility section would be more intuitive. > This section already discusses the necessary server versions and limitations. > Patch attached. This discussion tickles a conce

Re: Cross-version Compatibility of postgres_fdw

2024-08-12 Thread Fujii Masao
On 2024/08/09 17:49, Etsuro Fujita wrote: I just thought consolidating the information to one place would make the documentation more readable. Yes, so I think that adding a note about the required remote server version to the cross-version compatibility section would be more intuitive. This

Re: Cross-version Compatibility of postgres_fdw

2024-08-09 Thread Etsuro Fujita
On Wed, Aug 7, 2024 at 9:32 PM Fujii Masao wrote: > However, when using PostgreSQL 9.4 or earlier as a remote server, > INSERT ON CONFLICT on a foreign table fails because this feature > is only supported in v9.5 and later. Should we add a note to > the documentation to clarify this limitation? +

Cross-version Compatibility of postgres_fdw

2024-08-07 Thread Fujii Masao
Hi, The documentation states that postgres_fdw can be used with remote servers as far back as PostgreSQL 8.3. https://www.postgresql.org/docs/devel/postgres-fdw.html#POSTGRES-FDW-CROSS-VERSION-COMPATIBILITY However, when using PostgreSQL 9.4 or earlier as a remote server, INSERT ON CONFLICT on a