On Wed, 2009-03-11 at 14:27 -0700, Josh Berkus wrote: > I was just noticing that doing SET ROLE changes the current session's > priviledges, but not any runtime configuration parameters (like work_mem > or statement_timeout) associated with the new role. > > This is as documented (although I want to add a line to SET ROLE docs) > but is it the behavior we want? I for one would like SET ROLE to change > runtime configs.
Sounds good to me, but you may want to explore what problems that might cause so we can avoid screwing up. Perhaps it could be an option? -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers