RESET
Function
Restores run-time parameters to their default values. The default values are parameter default values complied in the postgresql.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 };
Parameter Description
- configuration_parameter
Specifies the name of a settable run-time parameter.
Value range: run-time 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 session authorization.
- ALL
Resets all settable run-time parameters to default values.
Examples
1 2 3 4 5 |
-- Reset timezone to the default value: openGauss=# RESET timezone; -- Set all parameters to their default values: openGauss=# RESET ALL; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot