Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

deallocate(7) [centos man page]

DEALLOCATE(7)						  PostgreSQL 9.2.7 Documentation					     DEALLOCATE(7)

DEALLOCATE - deallocate a prepared statement SYNOPSIS
DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends. For more information on prepared statements, see PREPARE(7). PARAMETERS
PREPARE This key word is ignored. name The name of the prepared statement to deallocate. ALL Deallocate all prepared statements. COMPATIBILITY
The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL. SEE ALSO
EXECUTE(7), PREPARE(7) PostgreSQL 9.2.7 2014-02-17 DEALLOCATE(7)

Check Out this Related Man Page

EXECUTE(7)                                                         SQL Commands                                                         EXECUTE(7)

EXECUTE - execute a prepared statement SYNOPSIS
EXECUTE name [ ( parameter [, ...] ) ] DESCRIPTION
EXECUTE is used to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the pre- pared statement must have been created by a PREPARE statement executed earlier in the current session. If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE statement, or else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of their parameters; the name of a prepared statement must be unique within a database session. For more information on the creation and usage of prepared statements, see PREPARE [prepare(7)]. PARAMETERS
name The name of the prepared statement to execute. parameter The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible with the data type of this parameter, as was determined when the prepared statement was created. OUTPUTS
The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE. EXAMPLES
Examples are given in the Examples [prepare(7)] section of the PREPARE [prepare(7)] documentation. COMPATIBILITY
The SQL standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a somewhat different syntax. SEE ALSO
DEALLOCATE [deallocate(7)], PREPARE [prepare(7)] SQL - Language Statements 2010-05-14 EXECUTE(7)
Man Page

11 More Discussions You Might Find Interesting

1. AIX

NIM From Linux Machine - Is it real?

Hello! My name is Daniel, and I have a "hard" question. I have 8 pSeries old servers, that I need to install from scratch every month - The OS version is AIX 5L 5.2 I have mksysb images of this computers (same image to all - same hardware), and I know that I can use NIM for this kind of... (16 Replies)
Discussion started by: dmor
16 Replies

2. Programming

Malloc problem with fread() to read file to structure in C

Hello, I am trying to read a text file into linked list, but always got the first and last records wrong. 1) The problem looks related to the initialization of the node temp with malloc(), but could not figure it out. No error/warning at compiling, though. 2) The output file is empty,... (10 Replies)
Discussion started by: yifangt
10 Replies

3. AIX

Unable to create a SPOT

Hi everyone! Ok so I'm trying for the first time to install AIX on a LPAR with NIM. The NIM: root@oaexpnimp01(/home/root) # oslevel -s 6100-08-02-1316 I'm trying to install AIX 6.1 TL1. I successfully created a new lpp source root@oaexpnimp01(/home/root) # lsnim -l AIX61_TL1_2... (10 Replies)
Discussion started by: trivium012
10 Replies

4. Programming

FORTRAN: Loop over variable file names

Hi guys I'm a beginner in fortran. So excuse me for my naivety, let me briefly describe what I was trying to do. I have let's say 2 files named reac-1 and reac-2. After opening these files I've to do some calculations, close these files and open the same files again in a loop. So my faulty code... (6 Replies)
Discussion started by: saleheen
6 Replies

5. Shell Programming and Scripting

Automation script

Hello All , I came across a tricky solution to devolop . Here is a part of the requirement automation . I have different set of server say : Web ( has 4 servers under it ) , App ( has 4 servers under it ) , DB ( has 2 servers under it ) Above each i have different load balancers , Say : Web... (4 Replies)
Discussion started by: radha254
4 Replies

6. Programming

Inexplicable buffer crash

I am building a wrapper around fgets, and fighting crashes for no reason I can explain. I have stripped it down as far as I can and it still crashes. #include <stdio.h> #include <stdlib.h> typedef struct { char buf; FILE *fp; int type; } wrap; wrap... (12 Replies)
Discussion started by: Corona688
12 Replies

7. Solaris

Could you run this benchmark? (Especially if you have a V880 or V890)

Hi all I am currently using a T5120 to write and run some simulation code I've been working on which heavily relies on large matrix multiplication procedures. I am posting this to call out for some of you run and share the results of a simple benchmark I've written to compare the matrix... (1 Reply)
Discussion started by: toguro123
1 Replies

8. Linux

Mismatch free() / delete / delete [C++]

Dear All, I got the valgrind report as below Mismatch free() / delete / delete at 0x4006895: operator delete(void*) (vg_replace_malloc.c:480) by 0x8EA6D11: corefunction. I supect that it is expect me to write free() instead of delete p1. Given the the code. I have the structure. ... (7 Replies)
Discussion started by: SA_Palani
7 Replies

9. UNIX for Beginners Questions & Answers

How to generate a large file in Linux ?

RHEL 7.3 In Linux, how can I create a large dummy file which is 15GB in size ? (4 Replies)
Discussion started by: kraljic
4 Replies

10. UNIX for Advanced & Expert Users

Ubuntu 14.04 - how to less ram usage

Hello, I have an ubuntu14.04 installed pc with 32GB ram. Operating System: Ubuntu 14.04.5 LTS Kernel: Linux 4.9.148-xxxx-std-ipv6-64 Architecture: x86_64 When I check free memory it shows: total used free shared buffers cached Mem: 31882 ... (2 Replies)
Discussion started by: baris35
2 Replies

11. UNIX for Beginners Questions & Answers

Unsure why access time on a directory change isn't changing

Hello... And thanks in advance for any help anyone can offer me I was trying to work out the differences between displaying modify, access, and change times with the 'ls' command. Everything seems in order when I look at files, but the access time on a directory doesn't seem to change when I... (4 Replies)
Discussion started by: bodisha
4 Replies