X-Git-Url: https://granicus.if.org/sourcecode?a=blobdiff_plain;f=doc%2Fsrc%2Fsgml%2Fref%2Freset.sgml;h=e94ef0b8d57e7d98105867262a818f649be0f7aa;hb=d13e903beaecd45a3721e4c2a7f9ff842ce94a79;hp=79b3b7d73c39270dcd639fdd92f6e0fcd3b5f4c9;hpb=a75f2d21a8366aece67b8aa144a8644f6195e75f;p=postgresql
diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml
index 79b3b7d73c..e94ef0b8d5 100644
--- a/doc/src/sgml/ref/reset.sgml
+++ b/doc/src/sgml/ref/reset.sgml
@@ -1,142 +1,157 @@
-
-
-
-RESET
-
-SQL - Language Statements
-
-
-
-RESET
-
-
-Restores run-time parameters for session to default values
-
-
-
-
-1998-09-24
-
-
-RESET variable
-
-
-
-
- 1998-09-24
-
-
- Inputs
-
-
-
-
-
- variable
-
-
-
- Refer to the SET statement for more information on available
- variables.
-
-
-
-
-
-
-
-
-
- 1998-09-24
-
-
- Outputs
-
-
-
-
-
-
- RESET VARIABLE
-
-
-
- Message returned if
- variable is successfully reset
- to its default value..
-
-
-
-
-
-
-
-
-
-
- 1998-09-24
-
-
- Description
-
-
- RESET restores variables to the
- default values.
- Refer to the SET command for details on
- allowed values and defaults.
- RESET is an alternate form for
-
- SET variable = DEFAULT
-
-
-
-
-
- 1998-09-24
-
-
- Notes
-
-
- The RESET statement is a Postgres language extension.
-
-
- Refer to SET/SHOW statements to set/show variable values.
-
-
-
-
-
-
- Usage
-
-
-
- -- reset DateStyle to its default;
- RESET DateStyle;
-
-
- -- reset Geqo to its default;
- RESET GEQO;
-
-
-
-
-
-
- Compatibility
-
-
-
-
- 1998-09-24
-
-
- SQL92
-
-
- There is no RESET in SQL92.
-
-
-
-
+
+
+
+
+ RESET
+ SQL - Language Statements
+
+
+
+ RESET
+ restore the value of a run-time parameter to the default value
+
+
+
+ RESET
+
+
+
+
+RESET configuration_parameter
+RESET ALL
+RESET { PLANS | SESSION | TEMP | TEMPORARY }
+
+
+
+
+ Description
+
+
+ RESET restores run-time parameters to their
+ default values. RESET is an alternative
+ spelling for
+
+SET configuration_parameter TO DEFAULT
+
+ Refer to for
+ details.
+
+
+
+ The default value is defined as the value that the parameter would
+ have had, if no SET> ever been issued for it in the
+ current session. The actual source of this value might be a
+ compiled-in default, the configuration file, command-line options,
+ or per-database or per-user default settings. See for details.
+
+
+
+ See the SET> reference page for details on the
+ transaction behavior of RESET>.
+
+
+
+ RESET> can also be used to release internal resources
+ that are usually released at the end of session. RESET
+ TEMP> drops all temporary tables created in the current session.
+ RESET PLANS> releases all internally cached plans.
+ RESET SESSION> releases all externally visible temporary
+ resources associated with the current session.
+
+
+
+
+ Parameters
+
+
+
+ configuration_parameter
+
+
+ The name of a run-time parameter. See for a list.
+
+
+
+
+
+ ALL
+
+
+ Resets all settable run-time parameters to default values.
+
+
+
+
+
+ TEMP, TEMPORARY
+
+
+ Drops all temporary tables created in the current session.
+
+
+
+
+
+ PLANS
+
+
+ Releases all cached query plans.
+
+
+
+
+
+ SESSION
+
+
+ Releases all temporary resources associated with the current
+ session. This has the same effect as executing the following
+ command sequence:
+
+SET SESSION AUTHORIZATION DEFAULT;
+RESET ALL;
+DEALLOCATE ALL;
+CLOSE ALL;
+UNLISTEN *;
+RESET PLANS;
+RESET TEMP;
+
+
+
+
+
+
+
+
+
+ Notes
+
+
+ RESET SESSION> cannot be executed inside a transaction block.
+
+
+
+
+ Examples
+
+
+ Set the geqo> configuration variable to its default value:
+
+RESET geqo;
+
+
+
+
+
+ Compatibility
+
+
+ RESET is a PostgreSQL extension.
+
+
+