From: | "Brad Smith" <bsmith(at)rdac(dot)com(dot)au> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | pgAdmin Error when trying to run a simple SELECT |
Date: | 2005-09-12 09:53:49 |
Message-ID: | A51777EE23640141A17640B11E6637FA036926@rdaex01.rdac.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
HelloCan anyone help with an error I'm suddenly getting in PgAdmin II.
My problem is this: Whenever I try to run an SQL statement like:
SELECT * from refUSERS;
I get an error:
ERROR: Relation "refusers" does not exist.
I've tried other simple SELECT statements but get the same message.
I can't for the life of me understand what's changed.
I can use other databases using the same login credentials and login
procedures and the error does not occur when using them; it only seems
to occur with this particular database. I can 'see' the database fine in
the Menu Tree. I can drill down to the tables and I can see the table
data by clicking on the Sunglasses icon - I just can't seem to run a
basic query.
Can any one help/suggest anything at all? Do I need to prefix the table
name with something? (although I never had to before)
Brad.
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-09-12 11:01:29 | Re: pgAdmin Error when trying to run a simple SELECT |
Previous Message | Raphaël Enrici | 2005-09-11 13:14:37 | Re: Pgadmin III connection error |