Thread: Did not find any relation named...

Did not find any relation named...

From
Mike Leahy
Date:
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

Re: Did not find any relation named...

From
Mike Leahy
Date:
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 majordomo@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