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 18:24:39 |
Message-ID: | OF6FF8D951.19E5B2C4-ON852571BF.0063E8E6-852571BF.00652279@michelin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(dot)campbell(at)us(dot)michelin(dot)com
"Rohit Prakash
Khare"
<rohitprakash123@ To
indiatimes.com> <greg(dot)campbell(at)us(dot)michelin(dot)com>
cc
08/03/2006 13:34
Subject
Re: Re: [ODBC] Error: relation does
Please respond to not exist
"Rohit Prakash
Khare"<rohitpraka
sh123(at)indiatimes(dot)
com>
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(dot)campbell(at)us(dot)michelin(dot)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(dot)campbell(at)us(dot)michelin(dot)com
Inactive hide details for "Rohit Prakash Khare" <rohitprakash123@
i!
ndiatimes.com>"Rohit Prakash Khare" <rohitprakash123(at)indiatimes(dot)com>
"Rohit Prakash
Khare"
<rohitprakash123@
indiatimes.com>
Sent by: To
pgsql-odbc-owner@
postgresql.org <pgsql-odbc(at)post
gresql.org>
08/03/2006 12:38 cc
Please respond to Subject
"Rohit Prakash
Khare"<rohitprakash123(at)indiatimes(dot)com> [ODBC] 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 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 | noreply | 2006-08-04 23:51:31 | [ psqlodbc-Bugs-1000699 ] Problem creating TableAdapter with WHERE parameter |
Previous Message | greg.campbell | 2006-08-03 17:23:01 | Re: Error: relation does not exist |