DISCARD(7) PostgreSQL 9.2.7 Documentation DISCARD(7)NAME
DISCARD - discard session state
SYNOPSIS
DISCARD { ALL | PLANS | TEMPORARY | TEMP }
DESCRIPTION
DISCARD 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.
PARAMETERS
TEMPORARY 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;
NOTES
DISCARD ALL cannot be executed inside a transaction block.
COMPATIBILITY
DISCARD is a PostgreSQL extension.
PostgreSQL 9.2.7 2014-02-17 DISCARD(7)
Check Out this Related Man Page
UNLISTEN(7) PostgreSQL 9.2.7 Documentation UNLISTEN(7)NAME
UNLISTEN - stop listening for a notification
SYNOPSIS
UNLISTEN { channel | * }
DESCRIPTION
UNLISTEN is used to remove an existing registration for NOTIFY events. UNLISTEN cancels any existing registration of the current
PostgreSQL session as a listener on the notification channel named channel. The special wildcard * cancels all listener registrations for
the current session.
NOTIFY(7) contains a more extensive discussion of the use of LISTEN and NOTIFY.
PARAMETERS
channel
Name of a notification channel (any identifier).
*
All current listen registrations for this session are cleared.
NOTES
You can unlisten something you were not listening for; no warning or error will appear.
At the end of each session, UNLISTEN * is automatically executed.
A transaction that has executed UNLISTEN cannot be prepared for two-phase commit.
EXAMPLES
To make a registration:
LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with PID 8448.
Once UNLISTEN has been executed, further NOTIFY messages will be ignored:
UNLISTEN virtual;
NOTIFY virtual;
-- no NOTIFY event is received
COMPATIBILITY
There is no UNLISTEN command in the SQL standard.
SEE ALSO LISTEN(7), NOTIFY(7)PostgreSQL 9.2.7 2014-02-17 UNLISTEN(7)
I am running a solaris 10 box and is just a workstation. I want to turn off the message below since it is annoying me.
Nov 15 12:16:07 stage5 in.routed: discard RIP response; source 134.56.105.2 not on interface eri0
This message only pops up when I am in a console. Telnet doesn't see it.
... (2 Replies)
hello everyone,
I'm having a problem doing signal handling so I post this thread to see if I could get help.
I want asynchronous signal handling, that means when I'm processing a signal (signal 1), if the same signal comes (signal 2) that signal (signal 2) shall be processed; and moreover,... (7 Replies)
I had a question about grep.
If I grep for something in a file, the output shows me all the lines in which that 'something' is contained in.
Is there a way to also output all the lines in which that 'something' wasnt contained in.
Say I have a file with a bunch of names and I do:
grep scott... (2 Replies)
Hi,
I'd get fields like
unix_linux_form_yyyyddmmhhmi.file.txt
shell_programming_and_scripting.txt
so on...
and want them as below
unix_linux_form
shell_programming_and
I could remove everything after a '.' as below
echo $field | sed 's/\..*//'
but how to remove... (14 Replies)
Hi all,
I'd like to search a file for the first occurence of the phrase "PLASTICS THAT EXPIRE" and then discard all the lines that came before it. Output the remainder to a new file. Operating system is hp-ux. I've searched for usual awk and sed one liners but can't find a solution.
Thank... (4 Replies)
Hi,
I'd like to do an operation on text with a format like this
this line shall be numbered
this line shall not be numbered
this line shall also be numbered
this line shall not not be numbered
And I want an output like this
1 this line shall be numbered
this line... (6 Replies)
Hi,
I have a lot of files similar to the below order. I want to rename all the files .discrading the time stamp/numbers after cnf.
Existing files
id_info_20130405.cnf_20130801
in_info_20130405.cnf_20130891
iz_info_20130405.cnf_20130821
in_info_20130405.cnf_20130818... (2 Replies)
I have the file:
s3_T0(2) Pos "1" "2"
s1_T1(2) Pos "1" "2"
---
0 0
1 0
0 1
1 1
---
1 2 "tau0"
1 2 "h10"
I want to patternmatch on ---
and get only the third part i.e.
1 2 "tau0"
1 2 "h10"
I wanted to start simple but even something like (5 Replies)
Hi guys !
I generated the power set of the set S={a,b,c} using crunch:
crunch 1 3 abc
and get the 39 possible subsets:
a
b
c
aa
ab
ac
ba
bb
bc
ca
cb
cc
… (2 Replies)