Josh Berkus <j...@agliodbs.com> writes: > Tom Lane wrote: >> The question is why this should be tied to SET ROLE, which already has >> well defined semantics that don't include any such behavior.
> Mostly because we don't have anywhere else to hang a "settings profile" > than ROLEs. So we should fix that, if we want a feature like this. > And currently, we can define settings with roles; the fact > that those settings materially only apply to login roles and not to > non-login roles could even be seen as inconsistent. [ shrug... ] The behavior of SET ROLE is defined by the standard. The behavior at login is not. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers