From: | "Kane Tao" <death(at)solaris1(dot)mysolution(dot)com> |
---|---|
To: | "Stephen Birch" <sbirch(at)ironmountainsystems(dot)com>, <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Table names case sensitive? |
Date: | 1999-11-25 05:25:08 |
Message-ID: | 000901bf3705$829796c0$040101c0@p2400arcane |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)ironmountainsystems(dot)com>
To: <pgsql-general(at)postgreSQL(dot)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)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-11-25 05:35:40 | Re: [GENERAL] Table names case sensitive? |
Previous Message | Stephen Birch | 1999-11-25 04:47:39 | Table names case sensitive? |