Re: Error: relation does not exist - Mailing list 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.campbell@us.michelin.com"Rohit Prakash Khare" <rohitprakash123@indiatimes.com>
Sent by: pgsql-odbc-owner@postgresql.org 08/03/2006 12:38
|
|
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@postgresql.org so that your
message can get through to the mailing list cleanly
Attachment
pgsql-odbc by date: