Re: Per-database and per-user GUC settings - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Per-database and per-user GUC settings
Date
Msg-id 29957.1012266109@sss.pgh.pa.us
Whole thread Raw
In response to Per-database and per-user GUC settings  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Per-database and per-user GUC settings  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> The basic functionality is done, although two issues sort of need a show
> of hands.  First, the order in which these settings are processed: I
> figured user should be last.

Meaning the user setting wins if there's a conflict?  Fine.

> I've also got these settings for each group,
> but this would mean that if a user is a member of more than one group he
> gets a rather random processing order.

That bothers me; seems like it'll bite someone sooner or later.  And I
don't see a compelling reason to have per-group settings if we have the
other two.

One issue you didn't mention is what security level these options are
assumed to have by GUC.  That plays into what permissions are needed to
issue the SET/ALTER commands.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bill Studenmund
Date:
Subject: Re: RFD: schemas and different kinds of Postgres objects
Next
From: Tom Lane
Date:
Subject: Re: Rules for accessing tuple data in backend code