Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] PQfnumber and quoted identifiers

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>,PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>,pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [HACKERS] PQfnumber and quoted identifiers
Date: 2003-10-05 17:43:26
Message-ID: 3F80583E.3030606@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
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




In response to

Responses

pgsql-hackers by date

Next:From: Matthew T. O'ConnorDate: 2003-10-05 17:56:08
Subject: Re: [HACKERS] PQfnumber and quoted identifiers
Previous:From: Tom LaneDate: 2003-10-05 17:00:07
Subject: Re: [HACKERS] PQfnumber and quoted identifiers

pgsql-interfaces by date

Next:From: Matthew T. O'ConnorDate: 2003-10-05 17:56:08
Subject: Re: [HACKERS] PQfnumber and quoted identifiers
Previous:From: Tom LaneDate: 2003-10-05 17:00:07
Subject: Re: [HACKERS] PQfnumber and quoted identifiers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group