Duplicate Columns showing up with PostgreSQL when quoted
I have an ODBC connection to PostgreSQL. When I select a table in the Visual Query Builder I get duplicate columns:
CREATE TABLE "UNICODE1"
"LineNumber" character varying(254),
"UNICODE" character varying(254)
My choices for the columns are
LineNumber character varying(254)
UNICODE character varying(254)
I have tracked it down to GetSchemaTable not returning the CaseSensitivity for the table properly. The first 2 are loaded with a SQL QUERY "LineNumber" and "UNICODE" which is correct and the second two from GetSchmeaTable without the Quotes.
I'm not sure if I am doing something wrong or if there is a step I have forgotten in setting up PostgreSQL isntallations
June 22 2010, 05:57 PM