RESET {session variable} - CockroachDB

The RESET statement resets a session variable to its default value for the client session.

Required privileges

No privileges are required to reset a session setting.

Synopsis

reset_session syntax diagram

Parameters

Parameter	Description
`session_var`	The name of the session variable.

Example

You can use SET.. TO DEFAULT to reset a session variable as well.

> SET extra_float_digits = -10;

> SHOW extra_float_digits;

 extra_float_digits
--------------------
 -10
(1 row)

> SELECT random();

 random
---------
 0.20286
(1 row)

> RESET extra_float_digits;

> SHOW extra_float_digits;

 extra_float_digits
--------------------
 0
(1 row)

> SELECT random();

      random
-------------------
 0.561354028296755
(1 row)

Known limitations

SET and RESET do not properly apply ROLLBACK within a transaction. For example, in the following transaction, showing the TIME ZONE variable does not return 2 as expected after the rollback:

SET TIME ZONE +2;
BEGIN;
SET TIME ZONE +3;
ROLLBACK;
SHOW TIME ZONE;

timezone
------------
3

See also