Re: Relation XX does not exist

PostgreSQL is case sensetive, so jobdetails is not the same as jobDetails.

Poul L. Christiansen

On Thu, 5 Apr 2001, Matt Allen wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>