From: | "Michael Coughlin" <MPCoughlin4(at)Home(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | error: Relation 'tableName' does not exist ? |
Date: | 2001-11-05 01:32:01 |
Message-ID: | 9s4pt6$2kli$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Unless I create a table, using psql, I've noticed that tables, that I
created with pgAccess or Microsoft Access, are NOT visible in pSQL i.e. I
get the error: "Relation 'tableName' does not exist". If I list tables,
using \d , psql can "see" the tables; yet, I can't select from them
without receiving "Relation 'tableName' does not exist".
I can link from MS Access to the pgAccess tables, just fine. pgaccess can
open the tables, just fine. I'm using the latest version, 7.1.3 of
PostgreSQL. I made sure that the database was NOT created using "root" and
that I was logged on as another User (which had created the database and
created the tables).
Why? Is there some permissions thing, that I missed?
Has anyone else run across this? ... and discovered why?
Michael Coughlin
401-348-9491
www.data-based-systems.com
From | Date | Subject | |
---|---|---|---|
Next Message | Christof Glaser | 2001-11-05 05:14:31 | Re: error: Relation 'tableName' does not exist ? |
Previous Message | Michael Coughlin | 2001-11-04 00:42:31 | tables invisible to pSQL |