Re: Relation XX does not exist - Mailing list pgsql-general

From Poul L. Christiansen
Subject Re: Relation XX does not exist
Date
Msg-id Pine.GSO.4.21.0104050827430.1479-100000@borg.cs.auc.dk
Whole thread Raw
In response to Relation XX does not exist  (Matt Allen <matt@investigationmarketplace.com>)
Responses Re: Relation XX does not exist
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Matt Allen
Date:
Subject: Relation XX does not exist
Next
From: Anand Raman
Date:
Subject: Re: Relation XX does not exist