Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 68F3C9FB696;
	Fri,  8 Jun 2007 17:36:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 82799-07; Fri,  8 Jun 2007 17:36:14 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254])
	by postgresql.org (Postfix) with ESMTP id 7465A9FB642;
	Fri,  8 Jun 2007 17:36:14 -0300 (ADT)
Received: from gauss.credativ.com (localhost [127.0.0.1])
	by gauss.credativ.com (Postfix) with ESMTP id 6DECFD7832;
	Fri,  8 Jun 2007 22:36:10 +0200 (CEST)
Received: from feivel (p54bbda34.dip.t-dialin.net [84.187.218.52])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by gauss.credativ.com (Postfix) with ESMTP id 6669AD782C;
	Fri,  8 Jun 2007 22:36:07 +0200 (CEST)
Received: by feivel (Postfix, from userid 1000)
	id 6898BD6D19; Fri,  8 Jun 2007 22:36:05 +0200 (CEST)
Date: Fri, 8 Jun 2007 22:36:06 +0200
From: Michael Meskes <meskes@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Meskes <meskes@postgresql.org>,
	PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: PQprepare case sensitive?
Message-ID: <20070608203606.GB24332@feivel.credativ.de>
Mail-Followup-To: Tom Lane <tgl@sss.pgh.pa.us>,
	Michael Meskes <meskes@postgresql.org>,
	PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
References: <20070608123351.GA30271@feivel.credativ.de>
	<22692.1181311002@sss.pgh.pa.us>
	<20070608145830.GB18853@feivel.credativ.de>
	<25652.1181315128@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <25652.1181315128@sss.pgh.pa.us>
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Virus-Scanned: ClamAV using ClamSMTP
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/10
X-Sequence-Number: 6579

On Fri, Jun 08, 2007 at 11:05:28AM -0400, Tom Lane wrote:
> 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.

Valid point. However, I had the statement name in a variable and used it
for prepare and deallocate. It just happened that it had upper case
letters and things didn't work. :-)

Anyway, I fix my code.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!