Re: TODO item: Allow more complex user/database default GUC settings

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TODO item: Allow more complex user/database default GUC settings
Date: 2009-08-26 02:17:38
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Alvaro Herrera wrote:

> Implementation-side, it requires a new catalog (pg_settings), with the
> following columns:

So, I've come up with the attached patch. It does not have the new
command yet, so you can do ALTER USER and ALTER DATABASE and it works,
but there's no way to set user-and-database-specific settings, short of
INSERT into the catalog. Apart from that it works nicely.

I'm just posting in case somebody has thoughts on the UI part of it.

Other things that need fixed:

- need to figure out locking for roles; this stuff must be synchronized
with role drop
- pg_shadow and pg_roles need a join to obtain settings
- two regression tests need their expected file updated
- catalog version bump

Alvaro Herrera
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Attachment Content-Type Size
setting.patch text/x-diff 41.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-26 02:32:50 Re: Unicode UTF-8 table formatting for psql text output
Previous Message WANGRUNGVICHAISRI, SHIVESH 2009-08-26 01:25:50 Re: BUG #4996: postgres.exe memory consumption keeps going up