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