From: | greg(dot)campbell(at)us(dot)michelin(dot)com |
---|---|
To: | "Rohit Prakash Khare" <rohitprakash123(at)indiatimes(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Error: relation does not exist |
Date: | 2006-08-03 17:23:01 |
Message-ID: | OF4709AFD8.51611653-ON852571BF.005E9DA0-852571BF.005F7DDF@michelin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Are the statements you pass using correct case and delimiters.
PostgreSQL will fold
"SELECT EMPLOYEES. NAME FROM EMPLOYEES"
into lower case e.g.
"SELECT employees.name FROM employees"
which produces the error if there is no "employees" table (the
table/relation is name EMPLOYEES or Employees).
The correction is to delimit the object names "SELECT 'EMPLOYEES'.'NAME'
FROM .'EMPLOYEES'". Notice the single quotes.
Of course most long time PostgreSQL users name all objects in lowercase to
avoid all the case folding/delimiting business.
Greg Campbell ENG-ASE/Michelin US5
Lexington, South Carolina
803-951-5561, x75561
Fax: 803-951-5531
greg(dot)campbell(at)us(dot)michelin(dot)com
"Rohit Prakash
Khare"
<rohitprakash123@ To
indiatimes.com> <pgsql-odbc(at)postgresql(dot)org>
Sent by: cc
pgsql-odbc-owner@
postgresql.org Subject
[ODBC] Error: relation does not
exist
08/03/2006 12:38
Please respond to
"Rohit Prakash
Khare"<rohitpraka
sh123(at)indiatimes(dot)
com>
Whenever I create a New Table using GUI PGAdmin III, and then call the
table from VB.NET 2003 using ODBC Connection, it displays an error:
"Relation does not exist".
But when I create a Table from command line console of PGSQL, then I have
no problems. Everything works fine. What is the problem.
...
RPK
Sign Up for your FREE eWallet at www.wallet365.comSign Up for your FREE
eWallet at www.wallet365.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | greg.campbell | 2006-08-03 18:24:39 | Re: Error: relation does not exist |
Previous Message | Rohit Prakash Khare | 2006-08-03 16:38:04 | Error: relation does not exist |