Skip site navigation (1) Skip section navigation (2)

Can't See Data - Plz Help!

From: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>
To: "Pgsql-Admin(at)Postgresql(dot)Org" <pgsql-admin(at)postgresql(dot)org>
Subject: Can't See Data - Plz Help!
Date: 2007-01-05 16:23:46
Message-ID: FBEGJLLJBCOMCDBJHIMEMEHDCCAA.jgeier@apt-cafm.com (view raw or flat)
Thread:
Lists: pgsql-admin
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


Responses

pgsql-admin by date

Next:From: ArnauDate: 2007-01-05 16:32:03
Subject: Problems restoring big tables
Previous:From: Tom LaneDate: 2007-01-05 15:49:50
Subject: Re: Recovering a deleted database problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group