relation does not exist - Mailing list pgsql-novice

From Robert Morgan
Subject relation does not exist
Date
Msg-id 4096F754.1010501@ihug.co.nz
Whole thread Raw
Responses Re: relation does not exist
List pgsql-novice
Trying to run this query:

    UPDATE tblMonitor SET Make = 'Phillips' WHERE Make = 'Ph*';

get the error message that " Error:  relation "tblMonitor" does not exist"

yet when I look at the relations it is there.

               List of relations
 Schema |         Name         | Type  | Owner
--------+------------------+------+------
 public | UpdatePC's           | table | bob
 public | lkpBuildings           | table | bob
 public | lkpCPU                 | table | bob
.......

public | tblWorkstation        | table | bob
(23 rows)


Bob




pgsql-novice by date:

Previous
From: Martin Hampl
Date:
Subject: Re: Query does not use index
Next
From: Stephan Szabo
Date:
Subject: Re: relation does not exist