diff options
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> |