> -----Original Message-----
> From: Schnetzer, Jerry [mailto:schnetzerj(at)nextnetwireless(dot)com]
> Sent: 20 November 2002 01:33
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Duplicate Table Names in PostgreSQL
> I have just started to use PostgreSQL. Among creating sql
> scripts to create my database and schema, I also need to
> export existing data from a MS SQL database. This has worked
> well using the postgreSQL ODBC driver in conjunction with MS
> Data Transformation Services (DTS) to export and move the
> data to PostgreSQL running on Linux.
> My question is this. When I run my create database scripts
> using psql, it converts all of my mixed table and column
> names into lower case; even though I have specified mixed
> names in the SQL script file. However, when I run DTS and
> export the data into the Postgres database (uses PostgreSQL
> ODBC), this process does in fact create a mixed table name in
> addition to the lower case version of the same table.
> Using psql, I can display the tables information (\dt) and
> see a display of both the lower and mixed case table.
> However, when I drop a table (specifying either a mixed or
> lower case name), PostgreSQL seems to only have one instance
> of the table. After dropping, a select statement against the
> table, is reported by psql, as not existing.
> How is this happening?
PostgreSQL folds unquoted names to lower case. DTS is presumably quoting
names whilst your scripts are not.
I would advise using all lowercase names if possible - it'll help avoid
any possible nasties in the future.
pgsql-odbc by date
|Next:||From: Dave Page||Date: 2002-11-26 20:16:28|
|Subject: Re: Install|
|Previous:||From: Benjamin Scherrey||Date: 2002-11-26 19:49:40|
|Subject: Can't get more than 255 chars out of memo field in Access 97.|