X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BCFAED1D167 for ; Tue, 13 Apr 2004 22:32:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83058-06 for ; Tue, 13 Apr 2004 22:32:26 -0300 (ADT) Received: from mail.socialserve.com (office.socialserve.com [208.60.89.34]) by svr1.postgresql.org (Postfix) with ESMTP id CA330D1D084 for ; Tue, 13 Apr 2004 22:32:22 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.socialserve.com (Postfix) with ESMTP id 9425697B2 for ; Tue, 13 Apr 2004 21:32:28 -0400 (EDT) Received: from mail.socialserve.com ([127.0.0.1]) by localhost (ms2 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17924-05 for ; Tue, 13 Apr 2004 21:32:24 -0400 (EDT) Received: from [192.168.1.101] (clt74-104-204.carolina.rr.com [24.74.104.204]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by mail.socialserve.com (Postfix) with ESMTP id 4A5A797B1 for ; Tue, 13 Apr 2004 21:32:23 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v613) Content-Transfer-Encoding: 7bit Message-Id: <92A0A6DA-8DB3-11D8-8D1B-000A9566A412@socialserve.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-docs@postgresql.org From: James Robinson Subject: Docs on PREPARE sql command should probably point to DEALLOCATE ... Date: Tue, 13 Apr 2004 21:32:20 -0400 X-Mailer: Apple Mail (2.613) X-Virus-Scanned: by amavisd-new at socialserve.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/15 X-Sequence-Number: 2359 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 Socialserve.com