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