Re: [GENERAL] Table names case sensitive?
От | Kane Tao |
---|---|
Тема | Re: [GENERAL] Table names case sensitive? |
Дата | |
Msg-id | 000901bf3705$829796c0$040101c0@p2400arcane обсуждение исходный текст |
Ответ на | Table names case sensitive? (Stephen Birch <sbirch@ironmountainsystems.com>) |
Ответы |
Re: [GENERAL] Table names case sensitive?
|
Список | pgsql-general |
Try exporting the tables (including table creation stmts) to a text file and then ASCII ftping the file to the Unix Server to convert the CRLF and import using pgsql...The documentation has the commands to import files... ----- Original Message ----- From: Stephen Birch <sbirch@ironmountainsystems.com> To: <pgsql-general@postgreSQL.org> Sent: Wednesday, November 24, 1999 11:47 PM Subject: [GENERAL] Table names case sensitive? > 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) >
В списке pgsql-general по дате отправления: