One other thing I've just thought of, if you issue a manual query from
within pgAdmin - does this succeed?
Also roughly how big are the tables (i.e. number of rows) - does it help
if you set a LIMIT in the SQL clause (by default I think it's 1000 rows
but try setting a LIMIT of 1 row and see if that comes back.)
Andy.
Jeanna Geier wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
