Re: Did not find any relation named...

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