There's a longstanding TODO item, in subject. Previous discussion was
In looking what it would take to implement it, I find that it is
trivial. The only part that looks complex is the UI for it. Is anyone
interested in giving this patch a shot?
Implementation-side, it requires a new catalog (pg_settings), with the
datconfig and rolconfig are removed.
ALTER DATABASE / SET sets setdatabase to the OID of the database in
command, and setrole to 0 (InvalidOid); ALTER ROLE / SET sets setrole
and leaves setdatabase 0.
A new command allows one to set a config that applies to both database
At startup, the settings are applied in the following order:
This way, current behavior is maintained (ALTER ROLE trumps ALTER
The only real work in this is figuring out what the grammar for the new
command looks like. Maybe we could have some like
ALTER ROLE foo ALTER DATABASE bar SET config
There are of course many possible variations but this looks the most
reasonable one. Any better ideas?
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
pgsql-hackers by date
|Next:||From: Peter Eisentraut||Date: 2009-08-11 22:22:34|
|Subject: Re: [COMMITTERS] pgsql: Ship documentation without intermediate tarballs Documentation|
|Previous:||From: Josh Berkus||Date: 2009-08-11 22:06:54|
|Subject: Re: Why is vacuum_freeze_min_age 100m?|