| 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: | Whole Thread | Raw Message | 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... |