Thread
-
Windows ODBC tables list (with 7.1 CVS)
Gena Gurchonok <gena@rt.mipt.ru> — 2000-12-14T07:15:45Z
============================================================================ 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. -
Re: Windows ODBC tables list (with 7.1 CVS)
Joel Burton <jburton@scw.org> — 2000-12-14T19:58:39Z
> 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)