Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 355DE9FC0FA; Fri, 8 Jun 2007 12:05:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 73078-04; Fri, 8 Jun 2007 12:05:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 070A99FBDF0; Fri, 8 Jun 2007 12:05:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l58F5SVf025653; Fri, 8 Jun 2007 11:05:28 -0400 (EDT) To: Michael Meskes cc: PostgreSQL Interfaces Subject: Re: PQprepare case sensitive? In-reply-to: <20070608145830.GB18853@feivel.credativ.de> References: <20070608123351.GA30271@feivel.credativ.de> <22692.1181311002@sss.pgh.pa.us> <20070608145830.GB18853@feivel.credativ.de> Comments: In-reply-to Michael Meskes message dated "Fri, 08 Jun 2007 16:58:30 +0200" Date: Fri, 08 Jun 2007 11:05:28 -0400 Message-ID: <25652.1181315128@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/9 X-Sequence-Number: 6578 Michael Meskes writes: > On Fri, Jun 08, 2007 at 09:56:42AM -0400, Tom Lane wrote: >> Yes, it's assumed that any quoting/dequoting has already happened by the >> time the name gets into the protocol message. > But shouldn't this be documented? I failed to find it. But then this > wouldn't be the first time I fail to find the right place in > documentation. Well, the point is that downcasing and quote-stripping are things that happen in the context of parsing names within SQL statements. We don't do that for other names that are sent by themselves in the protocol, such as user and database names in the startup message. So I would not expect it to happen for statement names either. regards, tom lane