Re: [PATCH] Release replication slot on error in SQL-callable slot functions

From: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
To: kedar anavardekar <kedar(dot)anavardekar(at)gmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [PATCH] Release replication slot on error in SQL-callable slot functions
Date: 2026-09-18 16:49:23
Message-ID: CALj2ACUYtfOcVGhbHuXLK-jCLVN=1pWQ0=Ba_KfeOup1PVJoug@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Fri, Sep 18, 2026 at 1:31 AM kedar anavardekar
<kedar(dot)anavardekar(at)gmail(dot)com> wrote:
>
> Two minor naming suggestions: (please take the suggestions if you
> think the points are valid)

Thanks for taking a look.

> 1. Could MyReplicationSlotSubId be renamed to
> MyReplicationSlotSubXactId (or MyReplicationSlotSubTransactionId)
>
> SubId may be read as a subscription ID, whereas this variable stores
> the SubTransactionId of the subtransaction that acquired
> MyReplicationSlot. The more explicit name would make its purpose
> clearer and avoid confusion with logical replication subscriptions.

Subscription and its related replication slot on the publisher are on
two different database instances, and one has the context when reading
the code around this. Also, "SubId" is used across the code base and I
want to keep it consistent and short, so MyReplicationSlotSubId looks
fine to me.

> 2., could the comment above AtEOSubXact_ReplicationSlot() be revised from:
> /*
> * At subxact end, release the replication slot if the subtransaction
> * where the slot was acquired is aborted.
> */
> to:
> /*
> * At subxact end, release the replication slot if the subtransaction
> * in which the slot was acquired is aborted.
> */
> “In which” is more precise here because the slot is acquired during
> that subtransaction.

I believe "where the slot was acquired" is grammatically correct as
well, so I'm fine with the existing wording.

--
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2026-09-18 16:54:34 Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)
Previous Message Bruce Momjian 2026-09-18 16:27:00 PG 19 status blog report