Re: PQfnumber and quoted identifiers

Peter Eisentraut wrote:

>There was a discussion on -interfaces that might need more consideration.
>
>http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00026.php
>
>
>Apparently, it has so far been an undocumented feature of libpq's function
>PGfnumber (return column number from column name) that the column name
>needs to be double-quoted if it contains upper-case letters. That, is you
>need to write
>
>PQfnumber(res, "\"Bar\"")
>
>I think this is completely bizarre and pointless. This is a C interface
>and not SQL. Other libpq functions that accept names of SQL objects don't
>do this. Also, PQfname and PQfnumber ought to be inverses.
>
>Since this behavior was undocumented and no one had noticed it in the last
>10 years, I think we can away with removing it.
>
>
I don't agree; you'll certainly break all libpq apps that contact
databases with columns that have uppercase or special chars, and the
failure might be very subtle because in most cases you wouldn't expect
that this function call fails after you successfully created a rowset.
There's no way how an app could determine which flavor of escaping is
necessary for PQfnumber.

I completely agree that PQfnumber should have been designed C-like right
from the start, at least this is how C programmers would expect it. I
had to learn the hard way that doesn't. While I don't have a problem
with either version, IMHO now it's far too late to change the behaviour.
As an alternative, a new function could be invented.

BTW, I'd suggest that libpq gets a PQversion() function or macro, so
that slight changes in behaviour could be taken in account on the app
side if necessary.

Regards,
Andreas