Re: PQfnumber and quoted identifiers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PQfnumber and quoted identifiers
Date
Msg-id 8636.1065378408@sss.pgh.pa.us
Whole thread Raw
In response to Re: PQfnumber and quoted identifiers  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: PQfnumber and quoted identifiers
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Peter Eisentraut wrote:
>> 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 agree.  I would never expect to add quotes to a C string to preserve
> case (outside SQL), and the fact that PQfname doesn't return the string
> in quotes is another inconsistency.

Actually I was planning to quiz you about the history.  I can see from
the CVS logs that you installed all the patches that added the
quoting/downcasing behavior.  Was there any discussion about it?
I dug through the mail archives and found

http://archives.postgresql.org/pgsql-ports/1997-05/msg00081.php
http://archives.postgresql.org/pgsql-bugs/1997-05/msg00023.php
http://archives.postgresql.org/pgsql-hackers/1997-11/msg00170.php

but I could not find any actual discussion about whether there was a
real bug or whether the complainants should be told to fix their code.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PQfnumber and quoted identifiers
Next
From: Stephan Szabo
Date:
Subject: Re: Open 7.4 items