Re: Can't See Data - Plz Help!

Thanks for the reply, Andy.

No, no error from pgadmin, and, yes, I can see all the properties of the
tables before opening it. You can open the tables and see menu bars and
what-not, just no data in the tables/views, but like I said, I know the data
is in there, because I can access it using psql from the command line.

We haven't tried any other client tools, but I'll give that a try, thanks.
And, if that doesn't help, I'll take your suggestion of asking on
pgadmin-support.

Thanks again!!
-Jeanna

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Andy Shellam
(Mailing Lists)
Sent: Friday, January 05, 2007 12:52 PM
To: Jeanna Geier
Cc: Pgsql-Admin(at)Postgresql(dot)Org
Subject: Re: [ADMIN] Can't See Data - Plz Help!

Hi Jeanna,

Does pgAdmin give you back any error, like permission denied, or
anything like that? Can you see all the properties of the table, such
as indexes, tables etc before you open it?
As it's happening on various PCs and versions of pgAdmin, I'd hazard a
guess that it's server-side, but I'm not sure.

Also have you tried any other client tools? EMS do a good PGSQL Manager
for free (the "Lite" version) - and you could use that to determine if
the problem is with the server or the client application, a different
tool may also highlight an error that pgAdmin does not. EMS is at
www.sqlmanager.net.

Might be worth asking on pgadmin-support(at)postgresql(dot)org as the
developers of pgAdmin can have a look-see too and might be able to
suggest other ideas.

Regards,

Andy.

Jeanna Geier wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:37,459e7bd3137101637590987!
>
>
>

--
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster