Re: Relation XX does not exist

Hi Poul
i guess u are gravely mistaken..
The table names in pgsql are not case sentive they are all case
insentive..b Try it out. However if u enclose the name in quotes and
create the table then it is case sensitive.. To access such tables u
willalways have to enclose then in quotes..

Anand

On Thu, Apr 05, 2001 at 08:28:43AM +0200, Poul L. Christiansen wrote:
>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)
>>