Skip site navigation (1) Skip section navigation (2)

Re: another idea for changing global configuration settings from SQL

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: another idea for changing global configuration settings from SQL
Date: 2012-11-16 14:59:35
Message-ID: 50A654D7.3060805@gmx.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On 11/15/12 12:53 PM, Peter Eisentraut wrote:
> All you'd need is to add
> 
> ApplySetting(InvalidOid, InvalidOid, relsetting, PGC_S_$SOMETHING);
> 
> in postinit.c, and have some SQL command to modify this setting.

Alright, any suggestions for the syntax?  We currently have

ALTER DATABASE ... SET ...
ALTER ROLE ... SET ...
ALTER ROLE ... IN DATABASE ... SET

I was thinking something like

ALTER ROLE ANY SET ...

in order to avoid creating a new top-level command, but it's not pretty.

Another way might be something like

SET GLOBAL name = value

but that would make the command very dissimilar from the other ones,
even though their effects are closely related.



In response to

Responses

pgsql-hackers by date

Next:From: Merlin MoncureDate: 2012-11-16 15:00:15
Subject: Re: Do we need so many hint bits?
Previous:From: Andres FreundDate: 2012-11-16 14:58:27
Subject: Re: Do we need so many hint bits?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group