Обсуждение: ALTER ROLE foo SET log_connections = true;

Hello,

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.

I find it a bit surprising as this wouldn't  affect the current session.

best regards,

Marc Mamin

"Marc Mamin" <M.Mamin@intershop.de> 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 other session, so the error is to let you know
you're doing something useless/ineffective.

            regards, tom lane