RE: [PATCH] Support automatic sequence replication - Mailing list pgsql-hackers

From Zhijie Hou (Fujitsu)
Subject RE: [PATCH] Support automatic sequence replication
Date
Msg-id TY4PR01MB1690715895CDE6FEFA13C2A2C947EA@TY4PR01MB16907.jpnprd01.prod.outlook.com
Whole thread Raw
In response to RE: [PATCH] Support automatic sequence replication  ("Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>)
Responses RE: [PATCH] Support automatic sequence replication
Re: [PATCH] Support automatic sequence replication
List pgsql-hackers
On Saturday, February 28, 2026 4:41 PM Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com> wrote:
> Here is the V8 patch set addressing the previous review comments:
> 
> - For 0001, I noticed that the GetSequence() function added in the patch
>   fetches the local sequence value without any privilege check. This
>   allows the worker to read sequence data even without proper SELECT
>   privilege, which seems unsafe. I've added a SELECT privilege check
>   before fetching the sequence value. Additionally, I've updated several
>   comments, made cosmetic changes, commit message update, and run
>   pgindent on all patches.
> 
> - 0002 includes the changes to synchronize sequences directly in the
>   REFRESH SEQUENCES command

Rebased the patch to silence compile warning due to a recent commit
a2c89835.

Best Regards,
Hou zj

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3
Next
From: Jakub Wartak
Date:
Subject: Re: pg_stat_io_histogram