Re: [19] CREATE SUBSCRIPTION ... SERVER

Álvaro Herrera <alvherre@kurilemu.de>

From: Álvaro Herrera <alvherre@kurilemu.de>

To: "Jeff Davis" <pgsql@j-davis.com>, "Amit Kapila" <amit.kapila16@gmail.com>

Cc: "Ashutosh Bapat" <ashutosh.bapat.oss@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>, "L. pgsql-hackers" <pgsql-hackers@postgresql.org>

Date: 2026-03-18T09:39:34Z

Lists: pgsql-hackers

On 2026-03-17, Jeff Davis wrote:

> Then we have to invent a deep copy for the Subscription, and we've
> already seen that the FreeSubscrpition() method was not being
> maintained properly.

Maybe another possibility would be to use a separate memory context for each subscription, initially making it a child of the transaction context, and then reparenting it as appropriate.

-- 
Álvaro Herrera

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Document new catalog columns, missed in commit 8185bb5347.
- 90630ec42939 19 (unreleased) landed
Refactor to remove ForeignServerName().
- 11f8018ee678 19 (unreleased) landed
GetSubscription(): use per-object memory context.
- f16f5d608ca6 19 (unreleased) landed
Fix dependency on FDW's connection function.
- 4a0b46b6e1e4 19 (unreleased) landed
ALTER SUBSCRIPTION ... SERVER test.
- 1c5bf1185af0 19 (unreleased) landed
Fix pg_dump for CREATE FOREIGN DATA WRAPPER ... CONNECTION.
- b71bf3b84570 19 (unreleased) landed
Clean up postgres_fdw/t/010_subscription.pl.
- f4af7849b3db 19 (unreleased) landed
CREATE SUBSCRIPTION ... SERVER.
- 8185bb534763 19 (unreleased) landed
Allow upgrades to preserve the full subscription's state.
- 9a17be1e244a 17.0 cited