X-Original-To: pgsql-interfaces@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 723A747580B for ; Sun, 6 Apr 2003 10:40:30 -0400 (EDT) Received: from smtp.web.de (smtp02.web.de [217.72.192.151]) by postgresql.org (Postfix) with ESMTP id B04FB474E42 for ; Sun, 6 Apr 2003 10:40:29 -0400 (EDT) Received: from [217.233.120.241] (helo=gigantix) by smtp.web.de with asmtp (WEB.DE(Exim) 4.97 #53) id 192BJx-00081p-00 for pgsql-interfaces@postgresql.org; Sun, 06 Apr 2003 16:40:33 +0200 From: "Denis Grannell" To: Subject: Problem seeing list of available tables in pgaccess Date: Sun, 6 Apr 2003 16:40:32 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-9.8 required=5.0 tests=BAYES_10,MSGID_GOOD_EXCHANGE,RCVD_IN_NJABL, RCVD_IN_OSIRUSOFT_COM autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/28 X-Sequence-Number: 3967 Hi, I wonder if anyone can help with the following: I have a postgres 7.3.2 installation on Solaris9 which I want to access from Windows PCs using pgaccess version 0.98.8.20030117. The windows version is Windows2000 Professional/SP3. The TclTk version on the PCs is V8.3 with cygwin. Pgaccess runs up without errors, but I'm not able to see any tables in the databases. I can see Queries, Views, Reports, Usergroups etc. If I select a query or a view and run it, it all works fine. I can also create new queries and views, save them, run them and they work perfectly, but if I select "Tables" in the explorer pane nothing happens. No list of tables, no error on the PC, no error in the postmaster logfile, nothing. If I access the Postgres server using the psql command line tool from the PCs, then I can list and access the tables without any problems whatsoever. I can also start pgaccess directly on the Solaris machine and everything works as you would expect, including listing the tables. Very mysterious! Anyone have any tips about how to troubleshoot something like this? thanks, Denis Grannell _________________________________________________________ | Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany | | Tel: +49 89 2013672 Fax: +49 89 2022875 | |_________________________________________________________|