Thread: Error: relation does not exist
Whenever I create a New Table using GUI PGAdmin III, and then call the table from VB.NET 2003 using ODBC Connection, it displaysan 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 theproblem. ... RPK Sign Up for your FREE eWallet at www.wallet365.comSign Up for your FREE eWallet at www.wallet365.com
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
You seem to have console access to your PG database. If I had a mysterious Relation does not exist
I would turn on statement logging. It is a switch in postgresql.conf. Uncomment log_statement = 'mod'.
I believe you have to restart PG to apply it. The switch is documented in the Postgresql 8.0 documentation.
And you need to have logging turned on. I did not see if you said the PostgreSQL server was Linux or Windows.
You will not want to leave log_statement on for very long.
Other logging option include ODBC tracing, and the PostgreSQL ODBC driver's option for MyLog.
Some of this should tell you if the problem is IN the pgodbc driver, or in how your applications statements are interacting with your PostgreSQL database.
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>
08/03/2006 13:34
|
|
Greg,
I tried many times and checked all the syntax. I even created a new table having no relation with other tables. I always use lower case SQL. Not following why it is happening.
greg.campbell@us.michelin.com wrote:
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