Thread: Windows ODBC tables list (with 7.1 CVS)

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               :       Gena Gurchonok
Your email address      :       gena@rt.mipt.ru


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : Intel Celeron

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.2.17

  PostgreSQL version (example: PostgreSQL-7.0):   PostgreSQL-7.1beta (CVS)

  Compiler used (example:  gcc 2.8.0)           : pgcc-2.91.66


Please enter a FULL description of your problem:
------------------------------------------------
I've used Windows ODBC driver to connect to database with previous
installation (7.0.2 - rpm version) and all was fine.
Now after upgrading to CVS version of postgres I have a problem - ODBC
tables list is EMPTY! But all applications that 'knows' table name can
access it normally.

It seems that 7.1beta incorrectly returns table list but all the rest
is fine.

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Install CVS verion of PSQL and try to connect to it with windows odbc
driver.

Tested on 2 different networks (with different dates of CVS release)


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

I don't know how to fix this.

> I've used Windows ODBC driver to connect to database with 
previous
> installation (7.0.2 - rpm version) and all was fine. Now after
> upgrading to CVS version of postgres I have a problem - ODBC 
tables
> list is EMPTY! But all applications that 'knows' table name can 
access
> it normally.
> 
> It seems that 7.1beta incorrectly returns table list but all the rest
> is fine.

The PG catalogs have changed enough from 7.0 to 7.1 that the old 
ODBC binaries don't work.

You can recompile the CVS source to a new ODBC driver. If you 
don't have VisualC++, you can my compiled copy from 
www.scw.org/pgaccess.

Good luck!

--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)