psqlodbc/iODBC/MacOSX/Office problem, no tables listed.

From: Giuliano Gavazzi <dev+pgsql(at)humph(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlodbc/iODBC/MacOSX/Office problem, no tables listed.
Date: 2003-01-13 23:16:14
Message-ID: a05200f20ba48f196f9cd@[10.0.1.4]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dear list,

I have just installed postgres 3.7.1 and psqlodbc-7.2.5 on a MacOS X
10.2 machine with iODBC (iODBC-SDK-3.5.3).
I have successfully connected using a test odbc application, I can
from this same application obtain the table list (it uses SQLTables).

The question:

My problem is that I cannot get the list of tables from Microsoft
Query in Excel for MacOS X.

I have snooped the communication and I have found this query :

select relname, nspname, relkind from pg_class, pg_namespace where
relkind in ('r','v') and relname !~ '^pg_|^dd_' and pg_namespace.oid
= relnamespace order by nspname, relname

this is the same that I can snoop for the test application, so I
guess it is how the driver translates SQLTables.

Also:

test=# select relname, nspname, relkind from pg_class, pg_namespace
test-# where relkind in ('r', 'v') and relname !~ '^pg_|^dd_'
test-# and pg_namespace.oid = relnamespace order by nspname,
test-# relname;
relname | nspname | relkind
---------+---------+---------
testt | public | r
(1 row)

and indeed the testt table was listed in the TCP stream.

I would say this is not a psqlodbc problem, but maybe some of you
might have come across it and found a solution.

Thanks for your time.

Giuliano
--
H U M P H
|| |||
software

Java & C++ Server/Client/Human Interface applications on MacOS - MacOS X
http://www.humph.com/

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-01-14 02:40:41 Re:
Previous Message Michael Wyraz 2003-01-13 13:53:29 Schema in ODBC table names