Re: Relation XX does not exist

Hi all,

ive tried the same insert statement on the command line too, with both caps and lower no go.

im connecting to pgsql though PHP compiles as a DSO though apache.

Its on a linux machine.

Matta

On Thu, Apr 05, 2001 at 09:22:28AM +0200, Poul L. Christiansen wrote:
> What client are you using to insert into table jobdetails? what OS are you
> running on the server and on the client?
> 
> Try to make the table names using lower case only and see if that works.
> 
> Poul L. Christiansen
> 
> On Thu, 5 Apr 2001, Matt Allen wrote:
> 
> > Hi Paul,
> > 
> > Ive tried both neither work.
> > 
> > Matt
> > 
> > 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)
> > > > 
> > > > 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
> > > > 
> > > 
> > > 
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > > 
> > > http://www.postgresql.org/search.mpl
> > 
> > -- 
> > Matt Allen
> > Technical Director
> > Investigation Marketplace
> > 0413 777 771
> > matt@investigationmarketplace.com
> > 

-- 
Matt Allen
Technical Director
Investigation Marketplace
0413 777 771
matt@investigationmarketplace.com