On Wed, Feb 20, 2008 at 7:34 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
>
> > 2) allow *commenting* of pg_settings / SET PERMANENT. Thus:
>
> > SET PERMANENT work_mem = '12mb' COMMENT '16mb too high; OOM';
>
> Ugh :-(
>
> I think that putting this into SET is a pretty bad idea in any case.
> SET is, and always has been, a session-local operation. Providing a
> secondary option that transforms it into something completely different
I think that's valid argument.
We already have ALTER USER foo SET bar = baz, so why not something like:
ALTER CLUSTER SET shared_buffers TO '2GB';
...perhaps with some other word than CLUSTER?
Regards,
Dawid
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
