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

From Robert Haas
Subject Re: Proposal to have INCLUDE/EXCLUDE options for altering option values
Date
Msg-id CA+Tgmob-MtTrr=9dYmXU-1tszc4wOUyj2zzd+M3AOV=kE6FhUA@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
On Mon, Aug 26, 2024 at 12:34 PM Ayush Vatsa <ayushvatsa1810@gmail.com> wrote:
> I noticed that my last commit needs rebase through cfbot - http://cfbot.cputube.org/ayush-vatsa.html
> PFA the rebased patch for the same.

Hi Ayush,

Thanks for working on this. One problem that I notice is that your
documentation changes seem to suppose that all options are lists, but
actually most of them aren't, and these new variants wouldn't be
applicable to non-list cases. They also suppose that everybody's using
comma-separated lists specifically, but that's not required and some
extensions might be doing something different. Also, I'm not convinced
that this problem would arise often enough in practice that it's worth
adding a feature to address it. A user who has this problem can pretty
easily do some scripting to address it - e.g. SELECT the current
option value, split it on commas, add or remove whatever, and then SET
the new option value. If that were something lots of users were doing
all the time, then I think it might make a lot of sense to have a
built-in solution to make it easier, but I doubt that's the case.

--
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch
Next
From: Robert Haas
Date:
Subject: Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch