diff options
author | Neil Conway <neilc@samurai.com> | 2007-04-26 16:13:15 +0000 |
---|---|---|
committer | Neil Conway <neilc@samurai.com> | 2007-04-26 16:13:15 +0000 |
commit | 16efdb5ec7f28bed9541fc773330e3e2ebe2ed9a (patch) | |
tree | 6ec0d0c7b08584ef53bf340e4d71a156e9655eba /doc/src/sgml/ref/reset.sgml | |
parent | 5ea27a4b2812d148f2516d130aee9dbaba45cedc (diff) | |
download | postgresql-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.sgml | 59 |
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> |