RESET

Description

Restores GUC parameters to their default values. The default values are parameter default values complied in the gaussdb.conf configuration file.

RESET is an alternative spelling for:

SET configuration_parameter TO DEFAULT;

Precautions

RESET and SET have the same transaction behavior. Their impact will be rolled back.

Syntax

RESET {configuration_parameter | CURRENT_SCHEMA | TIME ZONE | TRANSACTION ISOLATION LEVEL | SESSION AUTHORIZATION | ALL };

Parameters

configuration_parameter
Specifies the name of a GUC parameter.

Value range: GUC parameters. You can view them by running the SHOW ALL statement.

Some parameters that viewed by SHOW ALL cannot be set by SET, for example, max_datanodes.
CURRENT_SCHEMA
Specifies the current schema.
TIME ZONE
Specifies the time zone.
TRANSACTION ISOLATION LEVEL
Specifies the transaction isolation level.
SESSION AUTHORIZATION
Specifies the current user identifier of the current session.
ALL
Resets all GUC parameters to default values.

Examples

-- Set the time zone to Italy.
gaussdb=# SET timezone TO 'Europe/Rome';
-- View the current time zone.
gaussdb=# SHOW timezone;
  TimeZone   
-------------
 Europe/Rome
(1 row)

-- Set the time zone to the default value.
gaussdb=# RESET timezone;
-- View the current time zone.
gaussdb=# SHOW timezone;
 TimeZone 
----------
 PRC
(1 row)

-- The preceding SQL statement is equivalent to the following two SQL statements. Set the time zone to the default value.
gaussdb=# SET timezone TO DEFAULT;
gaussdb=# ALTER SESSION SET timezone to DEFAULT;