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.
