relation does not exist

From: Robert Morgan <robert_(at)ihug(dot)co(dot)nz>
To: postgres <pgsql-novice(at)postgresql(dot)org>
Subject: relation does not exist
Date: 2004-05-04 01:52:20
Message-ID: 4096F754.1010501@ihug.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2004-05-04 02:44:49 Re: relation does not exist
Previous Message Chari Clark 2004-05-03 20:20:13 Restoring a SQL Server 2000 database to PostGreSQL...