3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.1beta1 Documentation
7
.\" Source: PostgreSQL 9.1beta1
10
.TH "DISCARD" "7" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
22
DISCARD \- discard session state
27
DISCARD { ALL | PLANS | TEMPORARY | TEMP }
32
releases internal resources associated with a database session\&. These resources are normally released at the end of the session\&.
35
drops all temporary tables created in the current session\&.
37
releases all internally cached query plans\&.
39
resets a session to its original state, discarding temporary resources and resetting session\-local configuration changes\&.
44
Drops all temporary tables created in the current session\&.
49
Releases all cached query plans\&.
54
Releases all temporary resources associated with the current session and resets the session to its initial state\&. Currently, this has the same effect as executing the following sequence of statements:
60
SET SESSION AUTHORIZATION DEFAULT;
65
SELECT pg_advisory_unlock_all();
76
cannot be executed inside a transaction block\&.