Thread: 7.4 beta 1: SET log_statement=false

7.4 beta 1: SET log_statement=false

From
Bertrand Petit
Date:
Non superusers can set log_statement to true but can't set it
back to false even if log_statement was false at the begining of a
connection.

    I think lambda users should be able to revert log_statement to
false when false is the default setting.

--
%!PS
297.6 420.9 translate 90 rotate 0 setgray gsave 0 1 1{pop 0 180 moveto 100
180 170 100 170 -10 curveto 180 -9 180 -9 190 -10 curveto 190 100 100 180
0 180 curveto fill 180 rotate}for grestore/Bookman-LightItalic findfont
240 scalefont setfont -151.536392 -63.7998886 moveto (bp)show showpage

Re: 7.4 beta 1: SET log_statement=false

From
Tom Lane
Date:
Bertrand Petit <pgsql-bugs@phoe.frmug.org> writes:
>     Non superusers can set log_statement to true but can't set it
> back to false even if log_statement was false at the begining of a
> connection.

Yeah.  I think that the restrictions for USERLIMIT variables ought to
compare against the reset_val, not the session_val.

            regards, tom lane