Re: Proposal to have INCLUDE/EXCLUDE options for altering option values

Поиск
Список
Период
Сортировка
От Ayush Vatsa
Тема Re: Proposal to have INCLUDE/EXCLUDE options for altering option values
Дата
Msg-id CACX+KaPjO74Fe-w8npLgAhAGa+=eh28V8Qu0T+shKvHgGHtQgg@mail.gmail.com
обсуждение исходный текст
Ответ на Proposal to have INCLUDE/EXCLUDE options for altering option values  (Ayush Vatsa <ayushvatsa1810@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ayush Vatsa
Дата:
Сообщение: Proposal to have INCLUDE/EXCLUDE options for altering option values
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Row pattern recognition