Open search page
Hello, I’m DocuDroid!
Open Ask AI page
Submitting feedback
Thank you for rating our AI Search!
We would be grateful if you could share your thoughts so we can improve our AI Search for you and other readers.
GitHub

DISCARD

Discards the session state.

Synopsis

DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }

Description

DISCARD releases internal resources associated with a database session. This command is useful for partially or fully resetting the session’s state. There are several subcommands to release different types of resources. DISCARD ALL is not supported by Greengage DB.

Parameters

Parameter Description

PLANS

Releases all cached query plans, forcing re-planning to occur the next time the associated prepared statement is used

SEQUENCES

Discards all cached sequence-related state, including any preallocated sequence values that have not yet been returned by nextval(). See CREATE SEQUENCE for a description of preallocated sequence values

TEMPORARY/TEMP

Drops all temporary tables created in the current session

ALL

Releases all temporary resources associated with the current session and resets the session to its initial state.

NOTE

Greengage DB does not support DISCARD ALL and returns a notice message if you attempt to run the command.

As an alternative, you can run the following commands to release temporary session resources:

SET SESSION AUTHORIZATION DEFAULT;
RESET ALL;
DEALLOCATE ALL;
CLOSE ALL;
SELECT pg_advisory_unlock_all();
DISCARD PLANS;
DISCARD SEQUENCES;
DISCARD TEMP;

Compatibility

DISCARD is a Greengage DB extension.

Previous
DELETE
Next
DO