HomeActive Query BuilderDuplicate Columns showing up with PostgreSQL when quoted

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)
LineNumber String
UNICODE String

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
Linda Thompson | email
June 22 2010, 05:57 PM
This topic is closed