aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2013-10-03 16:17:18 -0400
committerRobert Haas <rhaas@postgresql.org>2013-10-03 16:23:31 -0400
commitd90ced8bb22194cbb45f58beb0961251103aeff5 (patch)
tree6f11b8ffc02e1eaeb3ba9d80bf5cfbf8f9232c09 /doc/src
parentc64e68fd9f1132fec563fb5de53dc3bcccb5fc3b (diff)
downloadpostgresql-d90ced8bb22194cbb45f58beb0961251103aeff5.tar.gz
postgresql-d90ced8bb22194cbb45f58beb0961251103aeff5.zip
Add DISCARD SEQUENCES command.
DISCARD ALL will now discard cached sequence information, as well. Fabrízio de Royes Mello, reviewed by Zoltán Böszörményi, with some further tweaks by me.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/discard.sgml12
1 files changed, 11 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/discard.sgml b/doc/src/sgml/ref/discard.sgml
index 65ebbae1385..762f8657116 100644
--- a/doc/src/sgml/ref/discard.sgml
+++ b/doc/src/sgml/ref/discard.sgml
@@ -21,7 +21,7 @@ PostgreSQL documentation
<refsynopsisdiv>
<synopsis>
-DISCARD { ALL | PLANS | TEMPORARY | TEMP }
+DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }
</synopsis>
</refsynopsisdiv>
@@ -67,6 +67,15 @@ DISCARD { ALL | PLANS | TEMPORARY | TEMP }
</varlistentry>
<varlistentry>
+ <term><literal>SEQUENCES</literal></term>
+ <listitem>
+ <para>
+ Discards all cached sequence values.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><literal>ALL</literal></term>
<listitem>
<para>
@@ -83,6 +92,7 @@ UNLISTEN *;
SELECT pg_advisory_unlock_all();
DISCARD PLANS;
DISCARD TEMP;
+DISCARD SEQUENCES;
</programlisting></para>
</listitem>
</varlistentry>