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
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 |