From: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
To: Jeanna Geier <jgeier@apt-cafm.com>
Cc: Pgsql-Admin@Postgresql.Org <pgsql-admin@postgresql.org>
Subject: Re: Can't See Data - Plz Help!
Date: Fri, 05 Jan 2007 19:52:08 +0000
Message-ID: <459EAC68.5060209@mailnetwork.co.uk> (raw)
In-Reply-To: <FBEGJLLJBCOMCDBJHIMEEEHHCCAA.jgeier@apt-cafm.com>
References: <FBEGJLLJBCOMCDBJHIMEEEHHCCAA.jgeier@apt-cafm.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andy.shellam-lists@mailnetwork.co.uk, jgeier@apt-cafm.com
Subject: Re: Can't See Data - Plz Help!
In-Reply-To: <459EAC68.5060209@mailnetwork.co.uk>
References: <FBEGJLLJBCOMCDBJHIMEEEHHCCAA.jgeier@apt-cafm.com> <459EAC68.5060209@mailnetwork.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox