diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-04-25 14:09:21 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-04-25 14:09:21 +0000 |
| commit | 6378fdd971eccc2ad4acd015b8e1baa27e0910a6 (patch) | |
| tree | c89984eacac792568d6f3f811840c5d1c9795042 /doc/src | |
| parent | 11fbdf2f25fef011e884c4b92157c7b0aed9e8b2 (diff) | |
| download | postgresql-6378fdd971eccc2ad4acd015b8e1baa27e0910a6.tar.gz postgresql-6378fdd971eccc2ad4acd015b8e1baa27e0910a6.zip | |
Add RESET CONNECTION, to reset all aspects of a session.
Hans-J?rgen Sch?nig
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/reset.sgml | 24 |
1 files changed, 21 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml index e94ad782cc9..42975740ac8 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.26 2003/12/14 00:15:03 neilc Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/reset.sgml,v 1.27 2006/04/25 14:09:06 momjian Exp $ PostgreSQL documentation --> @@ -11,7 +11,8 @@ PostgreSQL documentation <refnamediv> <refname>RESET</refname> - <refpurpose>restore the value of a run-time parameter to the default value</refpurpose> + <refpurpose>restore the value of a run-time parameter to the default value, + or reset all aspects of a session</refpurpose> </refnamediv> <indexterm zone="sql-reset"> @@ -22,6 +23,7 @@ PostgreSQL documentation <synopsis> RESET <replaceable class="PARAMETER">name</replaceable> RESET ALL +RESET CONNECTION </synopsis> </refsynopsisdiv> @@ -50,8 +52,11 @@ SET <replaceable class="parameter">parameter</replaceable> TO DEFAULT <para> See the <command>SET</> reference page for details on the - transaction behavior of <command>RESET</>. + transaction behavior of <command>RESET</>. <command>RESET + CONNECTION</command> can be used to reset all aspects of + a session, not just parameter values. </para> + </refsect1> <refsect1> @@ -76,7 +81,20 @@ SET <replaceable class="parameter">parameter</replaceable> TO DEFAULT </para> </listitem> </varlistentry> + + <varlistentry> + <term><literal>CONNECTION</literal></term> + <listitem> + <para> + Reset the all aspects of a session, including runtime parameters, + transaction status, temporary tables, <literal>WITH HOLD</literal> + cursors, prepared statements, and <command>LISTEN</command> + registrations. + </para> + </listitem> + </varlistentry> </variablelist> + </refsect1> <refsect1> |