Re: Per-database and per-user GUC settings

Peter Eisentraut <peter_e(at)gmx(dot)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