Skip site navigation (1) Skip section navigation (2)

ODBC driver and non case-insensitivity?

From: Chris Storah <cstorah(at)emis-support(dot)demon(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ODBC driver and non case-insensitivity?
Date: 2001-10-19 15:42:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Just searched the archives but no match for this problem that I can see:

Exporting an MS SQL 2000 table to PostgreSQL 7.1.3 fails due to uppercase 
table names.

MS SQL is set to quote all identifiers so the queries are sent in the format:
'create table TEST(ABC int)'
However, when MS SQL sends a query 'select * from test', the ODBC fails with 
"ERROR: Relation 'test' does not exist" as it is looking for the lowercase 
version of the table.

Through psql, the uppercase table names are converted into lowercase so 
PostgreSQL seems to be okay. Is this a problem with the ODBC driver?

If so, are there any patches available?



pgsql-bugs by date

Next:From: Cristiano Gonçalve e SouzaDate: 2001-10-19 16:53:34
Subject: Re: library path
Previous:From: Tom LaneDate: 2001-10-19 14:37:16
Subject: Re: library path

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group