Re: TODO item: Allow more complex user/database default GUC settings - Mailing list pgsql-hackers

From Robert Haas
Subject Re: TODO item: Allow more complex user/database default GUC settings
Date
Msg-id 603c8f070909271859p70e9fb1ao9b326c9360cbd76a@mail.gmail.com
Whole thread Raw
In response to Re: TODO item: Allow more complex user/database default GUC settings  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: TODO item: Allow more complex user/database default GUC settings
List pgsql-hackers
On Fri, Sep 25, 2009 at 8:05 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Alvaro Herrera escribió:
>
>> I think it can be solved by splitting OptRoleElem in a set of
>> productions for ALTER and a superset of that for ALTER.  I'll go try
>> that.
>
> Right, that works.  Updated patch attached; should solve the issues
> raised in the thread.  I renamed the catalog pg_db_role_setting as
> suggested by Tom.
>
> I have updated the pg_user and pg_roles definitions so that they include
> the settings for the role, but only those that are not specific to any
> database.
>
> I have also added a view, whose only purpose is to convert the role and
> database OIDs into names.  It's been named pg_db_role_settings, but if
> anyone has a better suggestion I'm all ears.

Bernd,

Can you review this new version and mark this as Ready for Committer
if it looks OK, or else respond with comments and set it back to
Waiting on Author?

Thanks,

...Robert


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: TODO item: Allow more complex user/database default GUC settings
Next
From: Robert Haas
Date:
Subject: Re: Unicode UTF-8 table formatting for psql text output