Relation XX does not exist

From: Matt Allen <matt(at)investigationmarketplace(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Relation XX does not exist
Date: 2001-04-05 06:53:16
Message-ID: 20010405165316.C1919@lappy.insider.ctrllab.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Guys,

Just started using PG today, bought the book and all was cruising along well untill i got the following error:

Relation 'jobdetails' does not exist

when i issued:

INSERT INTO jobdetails (jobDetailsID, jobID, claimName , claimNumber ,placementDate , completionDate, invType , insType) values
(7, 72,'P1234','Mr T',986453483,988639200, 'S', 'W')

All seems to be right here:

impmp=> \d
List of relations
Name | Type | Owner
----------------+----------+-------
jobDetails | table | impmp
jobdetails_seq | sequence | impmp
jobs | table | impmp
jobs_seq | sequence | impmp
(4 rows)

Any clues ? Ive restarted the SQL server and to no avail.

Thanks.
Matt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Poul L. Christiansen 2001-04-05 07:19:08 Re: Relation XX does not exist
Previous Message Poul L. Christiansen 2001-04-05 06:28:43 Re: Relation XX does not exist