Message-ID: <3F80583E.3030606@pse-consulting.de>
Date: Sun, 05 Oct 2003 19:43:26 +0200
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>,
	PostgreSQL Development <pgsql-hackers@postgresql.org>,
	pgsql-interfaces@postgresql.org
Subject: Re: [HACKERS] PQfnumber and quoted identifiers
References: <Pine.LNX.4.44.0310051632370.2745-100000@peter.localdomain>
	<3F803498.8080400@pse-consulting.de>
	<1258.1065373207@sss.pgh.pa.us>
In-Reply-To: <1258.1065373207@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Tom Lane wrote:

>That was pretty much the argument that carried the day in the earlier
>thread.  However, I'm not sure how many people really use PQfnumber
>(as opposed to hard-wiring assumptions about returned column numbers),
>and it would seem that the intersection of those people with people who
>use mixed-case column names may be nearly the empty set.  If a lot of
>people did this, the behavior would have been discussed and documented
>(or changed) long ago.  So I'm not convinced that we'd really break
>very many apps by changing to the behavior that everyone seems to agree
>is more sensible.
>  
>
...

>So other than the shortlived 6.2 release, releases before 6.5 had the
>behavior Peter wants.  I find it interesting that it took more than a
>year for anyone to notice that the putative dequoting+downcasing logic
>installed for 6.3 didn't work.
>
pgAdmin3 beta testers found it...

If you change it, please give me a chance to code it version-aware so 
quoting/non-quoting can be performed dependent on libpq in use.


Regards,
Andreas