Relation XX does not exist
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
You are right when it comes to the psql client, but I'm using ODBC on MS
Windows (with Cold Fusion and PgAdmin) and maybe he is using clients other
than psql to insert into PostgreSQL that has this problem.
Poul L. Christiansen
On Thu, 5 Apr 2001, Anand Raman wrote:
Show quoted text
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)
Import Notes
Reply to msg id not found: 20010405130530.R14051@india-today.com | Resolved by subject fallback