Bruce Momjian <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
