Re: [ADMIN] ALTER ROLE foo SET log_connections = true;

2012-03-16 Thread Tom Lane
"Marc Mamin" writes: > if I try to SET log_connections = true > (as super user, for another role) > I get the error: parameter "log_connections" cannot be set after > connection start. Yeah ... > I find it a bit surprising as this wouldn't affect the current session. Nor would it affect any

Re: [ADMIN] ALTER ROLE foo SET log_connections = true;

2012-03-16 Thread Raghavendra
Yep, it cannot be changed at session-level. http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Fri, Mar 16, 2012 at 5:24 PM, Marc Mamin wrote: > ** > > Hello, > > if I try to SET log_co

Re: [ADMIN] alter role

2006-01-21 Thread Tom Lane
Stijn De Weirdt <[EMAIL PROTECTED]> writes: > i am looking for a way to list the attributes for a given role. i looked into > the docs but didn't find anything directly usable. Look at the queries issued by psql for "\du" > on a related problem, what actually happens when you issue a > "ALTER R