Re: Relation XX does not exist

Started by Poul L. Christiansenabout 25 years ago6 messagesgeneral

Jump to latest

Poul L. Christiansen

poulc@cs.auc.dk

about 25 years ago

PostgreSQL is case sensetive, so jobdetails is not the same as jobDetails.

Poul L. Christiansen

On Thu, 5 Apr 2001, Matt Allen wrote:

Show quoted text

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

Import Notes

Reply to msg id not found: 20010405165316.C1919@lappy.insider.ctrllab.com

Anand Raman

araman@india-today.com

about 25 years ago

In reply to: Poul L. Christiansen (#1)

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

Show quoted text

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)

Matt Allen

matt@investigationmarketplace.com

about 25 years ago

In reply to: Anand Raman (#2)

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

Import Notes

Reply to msg id not found: Pine.GSO.4.21.0104050920020.1479-100000@borg.cs.auc.dkReference msg id not found: 20010405181126.D1919@lappy.insider.ctrllab.comReference msg id not found: Pine.GSO.4.21.0104050920020.1479-100000@borg.cs.auc.dk | Resolved by subject fallback

Joseph

lters@mrtc.com

about 25 years ago

In reply to: Matt Allen (#3)

RE: Relation XX does not exist

At the psql prompt you must put double quotes around table names that need
to be case sensitive...

Can you do
SELECT * FROM "jobDetails";

respectfully,
Joseph

Show quoted text

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Matt Allen
Sent: Thursday, April 05, 2001 5:36 AM
To: Poul L. Christiansen
Cc: Matt Allen; postgresql-general@postgresql.org
Subject: Re: [GENERAL] 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Joel Burton

jburton@scw.org

about 25 years ago

In reply to: Joseph (#4)

On Fri, 6 Apr 2001, Matt Allen wrote:

Hi,

Its all good ... any table name or column with a Cpaital letter in it needs to be enclosed in "" 's ...

Just out of curiostiy, which way do you guys do it?

jobdetails
job_details
or
"jobDetiails"

jobdetails. I don't find it hard to read, and prefer to use underscore
strategically, rather than to separate everyday words.

Typing all the quotes and shifting seems like way too much work, and opens
some confusions with different clients.

--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington

Import Notes

Reply to msg id not found: 20010406095323.C1844@lappy.insider.ctrllab.com | Resolved by subject fallback

Matt Allen

matt@investigationmarketplace.com

about 25 years ago

In reply to: Matt Allen (#3)

Hi,

Its all good ... any table name or column with a Cpaital letter in it needs to be enclosed in "" 's ...

Just out of curiostiy, which way do you guys do it?

jobdetails
job_details
or
"jobDetiails"

Thanks,

Matt

On Thu, Apr 05, 2001 at 06:01:54AM +0100, Ryan Mahoney wrote:

Try using quotes, ie: INSERT INTO "TableName" VALUES......

does that work?

-r

*snip*

Show quoted text

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.

Import Notes

Reply to msg id not found: 5.0.2.1.0.20010405060101.028eb140@paymentalliance.netReference msg id not found: Pine.GSO.4.21.0104050920020.1479-100000@borg.cs.auc.dkReference msg id not found: 20010405181126.D1919@lappy.insider.ctrllab.comReference msg id not found: Pine.GSO.4.21.0104050920020.1479-100000@borg.cs.auc.dk