Having been suitable impressed by the "PostgreSQL ready for mission
critical apps" thread, I decided to bite the bullet and convert our
database from Interbase to PostgreSQL. Almost immediately I encountered
a puzzling problem. To make things easy, I am using the Borland "data
pump" on an NT machine to copy our data from Interbase to PostgreSQL.
Although the PostgreSQL tables are created correctly, the write
operations are failing. It looks like the ODBC driver is attempting to
create tables with upper case names but PostgreSQL is converting the
names to lower case. When the data pump tries to write data into
PostgreSQL, the writes fail because the tables are not found since their
names are in now lower case.
It looks like PostgreSQL is not consistent with table case conversions.
For the heck of it, I hacked postres.c to convert the the SQL strings to
lower case on the fly - this kluge made the import work correctly.
I have searched the lists and FAQs to see if the table name case
disparity is a common problem, but drew a blank.
The attempted data flow is as follows:
Interbase 4.0 (SuSE 6.1 Linux) ---> Data Pump (NT) ---> PostgreSQL(SuSE
6.1 Linux)
Any suggestions?
Yeah, I know this is a convoluted way to copy data over - if you have
any better ideas, I'm all ears!
Steve