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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>