MIME-Version: 1.0
References: <15e7ae32-ee3b-4ba5-987a-8454fb6f07a4@app.fastmail.com>
 <202603181758.v4ft7uachdmm@alvherre.pgsql>
In-Reply-To: <202603181758.v4ft7uachdmm@alvherre.pgsql>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Sat, 21 Mar 2026 16:25:06 +0530
Message-ID: 
 <CAA4eK1J4_TNcckZEtkMD1519qDNn3G6eTBefXGbOJXeu_rhQNw@mail.gmail.com>
Subject: Re: [19] CREATE SUBSCRIPTION ... SERVER
To: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>
Cc: Jeff Davis <pgsql@j-davis.com>,
 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>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAA4eK1J4_TNcckZEtkMD1519qDNn3G6eTBefXGbOJXeu_rhQNw%40mail.gmail.com>
Precedence: bulk

On Wed, Mar 18, 2026 at 11:31=E2=80=AFPM =C3=81lvaro Herrera <alvherre@kuri=
lemu.de> wrote:
>
> On 2026-Mar-18, =C3=81lvaro Herrera wrote:
>
> > 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.
>
> I mean something like this on top of your 0003.
>

+1. This approach and patch looks like a better way to deal with this issue=
.

--=20
With Regards,
Amit Kapila.