| From: | "jerry(dot)evans(at)chordia" <jerry(dot)evans(at)chordia(dot)co(dot)uk> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Metadata/ODBC query |
| Date: | 2008-02-16 12:04:25 |
| Message-ID: | 037401c87094$142b9390$0565a8c0@p424 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
I'm experimenting with PostgreSQL 8.3.0 on Windows connecting via ODBC. One curiosity so far is this:
If I use pgAdmin and run "SELECT catalog_name FROM Information_Schema.Schemata" I get data back as expected.
If I connect via ODBC and issue the same query I don't see any data. SQLFetch() simply returns SQL_NO_DATA_FOUND. Both ODBC test apps work fine when accessing the same server/database running queries such as "SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE'"
I'm using the latest psqlODBC Windows installer from the web site. The driver is set to show system tables ...
Any clues?
Thanks.
Jerry.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-02-16 14:21:23 | Re: Metadata/ODBC query |
| Previous Message | Greg Smith | 2008-02-16 05:41:55 | Re: Are indexes blown? |