Re: Proposal to have INCLUDE/EXCLUDE options for altering option values - Mailing list pgsql-hackers

From Ayush Vatsa
Subject Re: Proposal to have INCLUDE/EXCLUDE options for altering option values
Date
Msg-id CACX+KaPjO74Fe-w8npLgAhAGa+=eh28V8Qu0T+shKvHgGHtQgg@mail.gmail.com
Whole thread Raw
In response to Proposal to have INCLUDE/EXCLUDE options for altering option values  (Ayush Vatsa <ayushvatsa1810@gmail.com>)
List pgsql-hackers
Added a CF entry for the same - https://commitfest.postgresql.org/48/4955/

Regards
Ayush Vatsa
Amazon Web Services (AWS)

On Fri, 26 Apr 2024 at 11:05, Ayush Vatsa <ayushvatsa1810@gmail.com> wrote:
Hi PostgreSQL Community,
Recently I have been working on foreign servers regarding my project and wanted to add some extensions in server options to support query pushdown. For this, suppose I had 20 extensions in the beginning I used ALTER SERVER srv OPTIONS (ADD EXTENSIONS 'all 20 extensions'), then again, I had to add a few or drop some, I had to write names of all the 20 extensions including/excluding some.
I wonder why we can't have some sort of INCLUDE / EXCLUDE option for this use case that can be useful for other options as well which have comma-separated values. I believe this is a useful feature to have for the users.
Since I needed that support, I took the initiative to contribute to the community. In addition, I have improved the documentation too as currently while reading the documentation it looks like ADD can be used multiple times even to include some values on top of existing values.
Attached is the patch for the same. Looking forward to your feedback.

Regards
Ayush Vatsa
Amazon Web Services (AWS)

pgsql-hackers by date:

Previous
From: Ayush Vatsa
Date:
Subject: Proposal to have INCLUDE/EXCLUDE options for altering option values
Next
From: Tatsuo Ishii
Date:
Subject: Re: Row pattern recognition