| Server IP : 94.16.115.136 / Your IP : 216.73.217.106 Web Server : Apache/2.4.52 (Ubuntu) System : Linux rogerrabbit 5.15.0-185-generic #195-Ubuntu SMP Fri Jun 19 17:11:50 UTC 2026 x86_64 User : bkillingseder ( 1001) PHP Version : 8.1.2-1ubuntu2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /snap/postgresql10/current/usr/share/man/man3/ |
Upload File : |
'\" t .\" Title: SPI_keepplan .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/> .\" Date: 2018 .\" Manual: PostgreSQL 10.4 Documentation .\" Source: PostgreSQL 10.4 .\" Language: English .\" .TH "SPI_KEEPPLAN" "3" "2018" "PostgreSQL 10.4" "PostgreSQL 10.4 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" SPI_keepplan \- save a prepared statement .SH "SYNOPSIS" .sp .nf int SPI_keepplan(SPIPlanPtr \fIplan\fR) .fi .SH "DESCRIPTION" .PP \fBSPI_keepplan\fR saves a passed statement (prepared by \fBSPI_prepare\fR) so that it will not be freed by \fBSPI_finish\fR nor by the transaction manager\&. This gives you the ability to reuse prepared statements in the subsequent invocations of your procedure in the current session\&. .SH "ARGUMENTS" .PP SPIPlanPtr \fIplan\fR .RS 4 the prepared statement to be saved .RE .SH "RETURN VALUE" .PP 0 on success; SPI_ERROR_ARGUMENT if \fIplan\fR is NULL or invalid .SH "NOTES" .PP The passed\-in statement is relocated to permanent storage by means of pointer adjustment (no data copying is required)\&. If you later wish to delete it, use \fBSPI_freeplan\fR on it\&.