Re: [HACKERS] PQfnumber and quoted identifiers - Mailing list pgsql-interfaces

From Andreas Pflug
Subject Re: [HACKERS] PQfnumber and quoted identifiers
Date
Msg-id 3F80583E.3030606@pse-consulting.de
Whole thread Raw
In response to Re: [HACKERS] PQfnumber and quoted identifiers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] PQfnumber and quoted identifiers  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-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





pgsql-interfaces by date:

Previous
From: Carsten Klein
Date:
Subject: Embedded SQL: Putting a guard around included stdio.h for convenience
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: [HACKERS] PQfnumber and quoted identifiers