Skip Menu |

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 23061
Status: rejected
Priority: 0/
Queue: DBD-Pg

People
Owner: Nobody in particular
Requestors: adroffner [...] optonline.net
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Catalog Functions and case sensitivity
Date: Sun, 12 Nov 2006 16:02:10 +0000 (GMT)
To: bug-dbd-pg [...] rt.cpan.org
From: adroffner [...] optonline.net
BUG: The column_info() method does not recognize uppercase database object names.FIX: Make all catalog functions convert database object names to lowercase with lc(), internally.It seems that DBD::Pg (v. 1.53 is installed) catalog functions do not match database object names, unless they are all lowercase. I am aware that PostgreSQL uses lowercase text in its data dictionary. Since this conflicts with the SQL standard of uppercase, please have the catalog functions be case insensitive.Also, the catalog functions documentation isn't so good. Can you point out that they are result-sets in the DBD::Pg docs, and to use the fetch_*() family of methods. Thank you, Andrew
If this is still an issue, please provide a test case: I cannot duplicate it on this end.
Closing ticket: no response in a long time.