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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

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

Browse pgsql-interfaces by date

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