Re: Should SET ROLE inherit config params? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Should SET ROLE inherit config params?
Date
Msg-id 8453.1237061076@sss.pgh.pa.us
Whole thread Raw
In response to Re: Should SET ROLE inherit config params?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Should SET ROLE inherit config params?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> What I want to be able to do is to set different bunches of resource 
> management settings for various non-login inherited roles, and be able 
> to choose profiles via a SET ROLE.  The reason to do this, btw, instead 
> of defining various login roles, is that different login roles can't 
> share the same connection pool.

The question is why this should be tied to SET ROLE, which already has
well defined semantics that don't include any such behavior.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: hstore improvements?
Next
From: Alvaro Herrera
Date:
Subject: Re: Has anybody think about changing BLCKSZ to an option of initdb?