Did not find any relation named...

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-10-01 03:48:52 Re: psql error: cannot open libpq.so.3
Previous Message Greg 2003-10-01 02:15:05 Re: Schema backup