By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,776 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,776 IT Pros & Developers. It's quick & easy.

Did not find any relation named...

P: n/a
Hello all,

I've got an issue with the ODBC component with PostgreSQL (v 7.3.4-2 in
Cygwin). I've connected to my DB using MS Access, and things seemed to be
working reasonably well.

However, when I exported a table to the DB from Access, while it shows up in
the list of tables in the DB, if I try to drop the table or use it in a query
from the PSQL command in cygwin, I get the following message:

Did not find any relation named <table_name>

So...while the data exist, and are visible in the list of table, and are also
totally useable by MS Access, it seems that PostgreSQL doesn't recognize their
existence. Any suggestions on how to fix this?

Thanks,
Mike

----------------------------------------
This mail sent through www.mywaterloo.ca

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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Thanks Joshua,

Using quotes did the trick...

Mike

Quoting "Joshua D. Drake" <jd@commandprompt.com>:
Hello,

You might have to put "" around the table name. Access has a tendency
to export table
names as all CAPS. Trying running the query through pass-through with
the "".

Sincerely,

Joshua Drake
Mike Leahy wrote:
Hello all,

I've got an issue with the ODBC component with PostgreSQL (v 7.3.4-2 in
Cygwin). I've connected to my DB using MS Access, and things seemed to be
working reasonably well.

However, when I exported a table to the DB from Access, while it shows up in

the list of tables in the DB, if I try to drop the table or use it in a

query
from the PSQL command in cygwin, I get the following message:

Did not find any relation named <table_name>

So...while the data exist, and are visible in the list of table, and are

also
totally useable by MS Access, it seems that PostgreSQL doesn't recognize

their
existence. Any suggestions on how to fix this?

Thanks,
Mike

----------------------------------------
This mail sent through www.mywaterloo.ca

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


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
Postgresql support, programming, shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL.Org - Editor-N-Chief - http://www.postgresql.org



----------------------------------------
This mail sent through www.mywaterloo.ca

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.