Re: [17] CREATE SUBSCRIPTION ... SERVER

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [17] CREATE SUBSCRIPTION ... SERVER
Date: 2023-08-30 13:49:45
Message-ID: 172273.1693403385@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> The server "myserver" must have been created with the new syntax:
> CREATE SERVER myserver FOR CONNECTION ONLY
> instead of specifying FOREIGN DATA WRAPPER. In other words, a server
> FOR CONNECTION ONLY doesn't have a real FDW, it's a special server just
> used for the postgres connection options.

This seems like it requires a whole lot of new mechanism (parser
and catalog infrastructure) that could be done far more easily
in other ways. In particular, how about inventing a built-in
dummy FDW to serve the purpose? That could have some use for
other testing as well.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2023-08-30 13:50:41 Re: pg_stat_get_backend_subxact() and backend IDs?
Previous Message Chapman Flack 2023-08-30 13:47:53 Re: Extract numeric filed in JSONB more effectively