From: | Terry Yapt <pgsql(at)technovell(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Schemas and ODBC driver. |
Date: | 2002-12-05 10:37:31 |
Message-ID: | 1039084651.81bc7e8pgsql@technovell.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
Hi all,
After my "import" from a 7.2.x to my 7.3 test server, I have tried to run my windows client applications (ODBC/Delphi 5).
I have obtained a 'Table is not indexed'. Hummm.... I am sure my first opening table have an index. But I am going to check it... Yes... it has an index...
In the client side (Delphi), if I try to get the indexes for that table, Delphi cannot find any of them... hummm.... Then, I see Delphi is trying to get the table indexes in this way 'user.table'.
The name of my table is 'foo', but NOT 'public.foo' nor 'user.foo'....
If I change the delphi table name from 'foo' to 'public.foo', then all was fine. But it mean I MUST TO MODIFY my client application completely...
:-((((
Perhaps in the ODBC side, if no schema is specified, PUBLIC schema must be queried...? Could be it a solution ?
ODBC: 7.02.00.05
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Witney | 2002-12-05 10:39:49 | Re: DbVisualizer and PG 7.3? |
Previous Message | Francois Suter | 2002-12-05 10:35:09 | Re: DbVisualizer and PG 7.3? |
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2002-12-05 10:49:39 | Re: Connections sitting idle... |
Previous Message | Hiroshi Inoue | 2002-12-05 10:09:56 | Re: Connections sitting idle... |