Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 74EEE9FA4DD for ; Fri, 5 Jan 2007 12:24:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 54895-06 for ; Fri, 5 Jan 2007 12:23:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from socrates.thinkhost.com (mailpipe.socrates.thinkhost.com [64.40.100.194]) by postgresql.org (Postfix) with ESMTP id D4B7F9FA589 for ; Fri, 5 Jan 2007 12:23:49 -0400 (AST) Received: from geier (adsl-64-91-71-139-rb.lax.customer.centurytel.net [64.91.71.139]) by socrates.thinkhost.com (8.13.6/8.13.5) with SMTP id l05GNdEA098863 for ; Fri, 5 Jan 2007 11:23:39 -0500 (EST) (envelope-from jgeier@apt-cafm.com) From: "Jeanna Geier" To: "Pgsql-Admin@Postgresql.Org" Subject: Can't See Data - Plz Help! Date: Fri, 5 Jan 2007 10:23:46 -0600 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.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/39 X-Sequence-Number: 24195 Hi List! I'm really in need of some guidance here.. We're running PostgreSQL 8.0 and I have PGAdmin v.1.4.3 on my local pc and version 1.2.2 on my server & the other developer's pc - when I open PGAdmin to connect to the database(s), I can do so without any problems, however, when we go to view the data in the database(s), we cannot see anything, the window opens with the menu bars, but there are no column names, and no data. And if I try a 'Refresh', it appears to do something, but still nothing is displayed. If I use a command prompt and connect to the db's, I can select from the tables and everything returns OK; and using our program, which connects to the db's using JDBC, it's connecting and returning data OK... However, not being able to view the data in the tables and views is an issue in our development and testing (not to mention sanity). It's happening on different databases, on multiple pc's, with different versions of the Admin tool. We haven't done any updates to either the database, our version of Postgres, or the Admin tool.... any thoughts??? Thanks in advance for your time and help! -Jeanna