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.

On Sep 12, 2005, at 5:53 AM, Brad Smith wrote:

> 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.
PostgreSQL folds unquoted identifiers to lower case. So if your
select has the correct spelling you need to use:

SELECT * from "refUSERS";


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings