aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/reset.sgml
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2007-04-26 16:13:15 +0000
committerNeil Conway <neilc@samurai.com>2007-04-26 16:13:15 +0000
commit16efdb5ec7f28bed9541fc773330e3e2ebe2ed9a (patch)
tree6ec0d0c7b08584ef53bf340e4d71a156e9655eba /doc/src/sgml/ref/reset.sgml
parent5ea27a4b2812d148f2516d130aee9dbaba45cedc (diff)
downloadpostgresql-16efdb5ec7f28bed9541fc773330e3e2ebe2ed9a.tar.gz
postgresql-16efdb5ec7f28bed9541fc773330e3e2ebe2ed9a.zip
Rename the newly-added commands for discarding session state.
RESET SESSION, RESET PLANS, and RESET TEMP are now DISCARD ALL, DISCARD PLANS, and DISCARD TEMP, respectively. This is to avoid confusion with the pre-existing RESET variants: the DISCARD commands are not actually similar to RESET. Patch from Marko Kreen, with some minor editorialization.
Diffstat (limited to 'doc/src/sgml/ref/reset.sgml')
-rw-r--r--doc/src/sgml/ref/reset.sgml59
1 files changed, 1 insertions, 58 deletions
diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml
index e98f7ff56c6..355de891287 100644
--- a/doc/src/sgml/ref/reset.sgml
+++ b/doc/src/sgml/ref/reset.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/reset.sgml,v 1.34 2007/04/12 22:34:45 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/reset.sgml,v 1.35 2007/04/26 16:13:09 neilc Exp $
PostgreSQL documentation
-->
@@ -22,7 +22,6 @@ PostgreSQL documentation
<synopsis>
RESET <replaceable class="PARAMETER">configuration_parameter</replaceable>
RESET ALL
-RESET { PLANS | SESSION | TEMP | TEMPORARY }
</synopsis>
</refsynopsisdiv>
@@ -53,15 +52,6 @@ SET <replaceable class="parameter">configuration_parameter</replaceable> TO DEFA
See the <command>SET</> reference page for details on the
transaction behavior of <command>RESET</>.
</para>
-
- <para>
- <command>RESET</> can also be used to release internal resources
- that are usually released at the end of session. <command>RESET
- TEMP</> drops all temporary tables created in the current session.
- <command>RESET PLANS</> releases all internally cached plans.
- <command>RESET SESSION</> releases all externally visible temporary
- resources associated with the current session.
- </para>
</refsect1>
<refsect1>
@@ -86,57 +76,10 @@ SET <replaceable class="parameter">configuration_parameter</replaceable> TO DEFA
</para>
</listitem>
</varlistentry>
-
- <varlistentry>
- <term><literal>TEMP, TEMPORARY</literal></term>
- <listitem>
- <para>
- Drops all temporary tables created in the current session.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
- <term><literal>PLANS</literal></term>
- <listitem>
- <para>
- Releases all cached query plans.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
- <term><literal>SESSION</literal></term>
- <listitem>
- <para>
- Releases all temporary resources associated with the current
- session. This has the same effect as executing the following
- command sequence:
-<programlisting>
-SET SESSION AUTHORIZATION DEFAULT;
-RESET ALL;
-DEALLOCATE ALL;
-CLOSE ALL;
-UNLISTEN *;
-RESET PLANS;
-RESET TEMP;
-</programlisting>
- </para>
- </listitem>
- </varlistentry>
-
</variablelist>
</refsect1>
<refsect1>
- <title>Notes</title>
-
- <para>
- <command>RESET SESSION</> cannot be executed inside a transaction block.
- </para>
- </refsect1>
-
- <refsect1>
<title>Examples</title>
<para>