.\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ DISCARD - Online Linux Manual PageSection : 7
Updated : 2014-02-17
Source : SQL - Language Statements
Note : SQL Commands

NAMEDISCARD − discard session state

SYNOPSISDISCARD { ALL | PLANS | TEMPORARY | TEMP }

DESCRIPTIONDISCARD releases internal resources associated with a database session. These resources are normally released at the end of the session. DISCARD TEMP drops all temporary tables created in the current session. DISCARD PLANS releases all internally cached query plans. DISCARD ALL resets a session to its original state, discarding temporary resources and resetting session-local configuration changes.

PARAMETERSTEMPORARY or TEMP  Drops all temporary tables created in the current session. PLANS  Releases all cached query plans. ALL  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: SET SESSION AUTHORIZATION DEFAULT; RESET ALL; DEALLOCATE ALL; CLOSE ALL; UNLISTEN *; SELECT pg_advisory_unlock_all(); DISCARD PLANS; DISCARD TEMP;

NOTESDISCARD ALL cannot be executed inside a transaction block.

COMPATIBILITYDISCARD is a PostgreSQL extension.
0
Johanes Gumabo
Data Size   :   5,025 byte
man-discard.7Build   :   2024-12-05, 20:55   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   2 / 203,492
Visitor ID   :     :  
Visitor IP   :   18.223.195.30   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   1000   :  
Provider City   :   Columbus   :  
Provider Province   :   Ohio ,   :   ,
Provider Country   :   United States   :  
Provider Continent   :   North America   :  
Visitor Recorder   :   Version   :  
Visitor Recorder   :   Library   :  
Online Linux Manual Page   :   Version   :   Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 24.12.05
Online Linux Manual Page   :   Library   :   lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page   :   Library   :   lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base   :   Version   :   Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base   :   Library   :   lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36

Very long time ago, I have the best tutor, Wenzel Svojanovsky . If someone knows the email address of Wenzel Svojanovsky , please send an email to johanes_gumabo@yahoo.co.id .
If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.

ERROR : Need New Coding :         (rof_escape_sequence|91|discard.7|1|\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ |.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ )         (parse_manual_page_|249|discard.7|1|\"|.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ )