summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian2004-04-19 23:36:48 +0000
committerBruce Momjian2004-04-19 23:36:48 +0000
commitd1b3915ce181938a432b1098aa6bf4d47c721a98 (patch)
tree04b3be5cf0c69bd2c3cc5fbdbf614f7c4f3e2915 /doc/src
parent011c3e62e78b02a573f6f59ce78b1e7515d380c0 (diff)
In reading the 7.4.2 docs, the sql reference page for PREPARE doesn't
reference DEALLOCATE in any way. It points to EXECUTE, but not to DEALLOCATE. Suggested fix: ... This also means that a single prepared statement cannot be used by multiple simultaneous database clients; however, each client can create their own prepared statement to use. The prepared statement can be manually cleaned up using the DEALLOCATE command. James Robinson
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/prepare.sgml11
1 files changed, 6 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml
index 780c5231c4b..6a77048c3eb 100644
--- a/doc/src/sgml/ref/prepare.sgml
+++ b/doc/src/sgml/ref/prepare.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.11 2004/01/26 17:26:31 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.12 2004/04/19 23:36:48 momjian Exp $
PostgreSQL documentation
-->
@@ -54,10 +54,11 @@ PREPARE <replaceable class="PARAMETER">plan_name</replaceable> [ (<replaceable c
<para>
Prepared statements only last for the duration of the current
database session. When the session ends, the prepared statement is
- forgotten, so it must be recreated before being used again. This
- also means that a single prepared statement cannot be used by
- multiple simultaneous database clients; however, each client can
- create their own prepared statement to use.
+ forgotten, so it must be recreated before being used again. This
+ also means that a single prepared statement cannot be used by
+ multiple simultaneous database clients; however, each client can create
+ their own prepared statement to use. The prepared statement can be
+ manually cleaned up using the <command>DEALLOCATE</> command.
</para>
<para>