Re: [17] CREATE SUBSCRIPTION ... SERVER - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: [17] CREATE SUBSCRIPTION ... SERVER
Date
Msg-id 830a2bc6cbbb2e6e01c6c0d9f31f320822e10603.camel@j-davis.com
Whole thread Raw
In response to Re: [17] CREATE SUBSCRIPTION ... SERVER  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Responses Re: [17] CREATE SUBSCRIPTION ... SERVER
List pgsql-hackers
On Wed, 2023-08-30 at 19:11 +0530, Ashutosh Bapat wrote:
> Are you suggesting that SERVERs created with FDW can not be used as
> publishers?

Correct. Without that, how would the subscription know that the FDW
contains valid postgres connection information? I suppose it could
create a connection string out of the options itself and do another
round of validation, is that what you had in mind?

> We can push down a join
> between a replicated table and foreign table down to the foreign
> server.

Interesting idea.

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Chapman Flack
Date:
Subject: Re: More new SQL/JSON item methods
Next
From: Bruce Momjian
Date:
Subject: Re: Debian 12 gcc warning