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.