Re: Relation XX does not exist
От | Matt Allen |
---|---|
Тема | Re: Relation XX does not exist |
Дата | |
Msg-id | 20010405193532.E1919@lappy.insider.ctrllab.com обсуждение исходный текст |
Ответ на | Relation XX does not exist (Matt Allen <matt@investigationmarketplace.com>) |
Ответы |
RE: Relation XX does not exist
("Joseph" <lters@mrtc.com>)
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: