Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id F069C63454C for ; Mon, 5 Oct 2009 19:06:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 65849-01-3 for ; Mon, 5 Oct 2009 22:06:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp162.dfw.emailsrvr.com (smtp162.dfw.emailsrvr.com [67.192.241.162]) by mail.postgresql.org (Postfix) with ESMTP id 22388636490 for ; Mon, 5 Oct 2009 19:06:48 -0300 (ADT) Received: from relay6.relay.dfw.mlsrvr.com (localhost [127.0.0.1]) by relay6.relay.dfw.mlsrvr.com (SMTP Server) with ESMTP id 8552830140 for ; Mon, 5 Oct 2009 18:06:46 -0400 (EDT) Received: by relay6.relay.dfw.mlsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 5F64B30072 for ; Mon, 5 Oct 2009 18:06:46 -0400 (EDT) Message-Id: From: Christophe Pettus To: pgsql-php@postgresql.org In-Reply-To: <4ACA6D38.4010005@gmx.de> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: checking select query syntax and semantics via php without executing Date: Mon, 5 Oct 2009 15:06:45 -0700 References: <4ACA6668.2000701@gmx.de> <20091005180139.25cc9511.wmoran@potentialtech.com> <4ACA6D38.4010005@gmx.de> X-Mailer: Apple Mail (2.936) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=AWL=0.000, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/5 X-Sequence-Number: 4084 On Oct 5, 2009, at 3:03 PM, Marco Dieckhoff wrote: > Must be one of the quickest "case solved, thread closed" I have ever > seen :) And you can present the user with the query plan, so they can tell if they are about to do something horrible to the database. :) -- -- Christophe Pettus xof@thebuild.com