Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E982F6331A6 for ; Sun, 20 Dec 2009 21:30:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00434-01-7 for ; Mon, 21 Dec 2009 01:30:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from a2s36.a2hosting.com (a2s36.a2hosting.com [74.126.18.130]) by mail.postgresql.org (Postfix) with ESMTP id 883F4632CD4 for ; Sun, 20 Dec 2009 21:30:16 -0400 (AST) Received: from adsl-70-115-193.tys.bellsouth.net ([98.70.115.193] helo=[192.168.1.18]) by a2s36.a2hosting.com with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.69) (envelope-from ) id 1NMX6C-0001L5-Sf; Sun, 20 Dec 2009 20:30:13 -0500 Subject: Re: Extended Query, flush or sync ? Mime-Version: 1.0 (Apple Message framework v1077) Content-Type: text/plain; charset=us-ascii From: John DeSoi In-Reply-To: <201B449B-118E-43A6-A413-4709A8FD463C@montx.com> Date: Sun, 20 Dec 2009 20:30:11 -0500 Cc: pgsql-general List Content-Transfer-Encoding: quoted-printable Message-Id: <03F6E9C9-59AF-4F9B-837A-822C224DCD22@pgedit.com> References: <92781008-8A70-42CE-A49B-6EE67103FACB@montx.com> <20091026231516.GN8812@alvh.no-ip.org> <4AE62E21.7040600@hogranch.com> <66F15D69-75E5-4D8E-84F8-2F21E09BBA98@pgedit.com> <9A9F2678-36B9-42A2-91B2-69076065E8EB@montx.com> <20091027134158.GB4876@alvh.no-ip.org> <4AB34FE9-CC23-48BE-B905-6478304E0E5B@montx.com> <20091027140657.GF4876@alvh.no-ip.org> <4B057205.6000203@gmail.com> <322BBEA5-A328-4197-971E-95359D8FD7F3@montx.com> <4B05A8D4.7020500@gmail.com> <6A231EA8-5255-47F3-BECB-9BFBD700044C@montx.com> <20879F35-6940-4272-988E-703E610C6212@montx.com> <57FE8BF9-5E03-4F5A-9BBA-A06118CC2E3B@pgedit.com> <0AADF4A5-E795-4F2D-AA2B-A4E1A4BD 9D93@montx.com> <1224664A-9C2B-4CE2-888C-7F50F7556BBD@pgedit.com> <201B449B-118E-43A6-A413-4709A8FD463C@montx.com> To: Raimon Fernandez X-Mailer: Apple Mail (2.1077) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s36.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200912/830 X-Sequence-Number: 157050 Hi Raimon, On Dec 20, 2009, at 2:11 PM, Raimon Fernandez wrote: >=20 > I'm not seeing my e-mails on the PostgreSQL General List ... >=20 > ?????? Yes, my last message did not make it to the list yesterday (you = obviously received it). I double checked and it was cc to the list. > I can pack all of them and send them at the same time, except de = Parse, that will go at the connection beggining in my case. I have two routines, prepare and exec_prepare. To prepare a named statement for multiple uses, I use prepare (parse, = describe, sync). exec_prepare can take a statement from prepare OR you can pass it the = unparsed SQL instead (along with the parameters). In the second case it = performs the parse first with the unnamed prepared statement (empty = string) and then executes it. This is nice because if you don't need = multiple executions, you can build and execute with a single network = write and read. You get the safety of parameterized execution and you = don't have a prepared statement to dispose of in another operation. John DeSoi, Ph.D.