Did not find any relation named...

[Mike Leahy]

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)

[Mike Leahy]

Thanks Joshua,

Using quotes did the trick...

Mike

Quoting "Joshua D. Drake" <[e-mail]>:

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.
[phone] - [e-mail] - 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