Re: Did not find any relation named...

From: Mike Leahy <mgleahy(at)fes(dot)uwaterloo(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Did not find any relation named...
Date: 2003-10-01 05:45:37
Message-ID: 1064987137.3f7a6a01455cb@www.nexusmail.uwaterloo.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Joshua,

Using quotes did the trick...

Mike

Quoting "Joshua D. Drake" <jd(at)commandprompt(dot)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(at)postgresql(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
> PostgreSQL.Org - Editor-N-Chief - http://www.postgresql.org
>
>

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2003-10-01 08:28:35 Re: mod_auth_pgsql 2.0.1 don't close the backend connection
Previous Message Tom Lane 2003-10-01 03:48:52 Re: psql error: cannot open libpq.so.3