Schemas and ODBC driver.

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

Responses

Browse pgsql-general by date

  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?

Browse pgsql-odbc by date

  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...