Lists: | pgsql-interfaces |
---|
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 |
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: | Christof Glaser <gcg(at)gl(dot)aser(dot)de> |
---|---|
To: | "Michael Coughlin" <MPCoughlin4(at)Home(dot)com>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: error: Relation 'tableName' does not exist ? |
Date: | 2001-11-05 05:14:31 |
Message-ID: | 20011105050250.274E7636A4@gl.aser.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
On Monday, 5. November 2001 02:32, Michael Coughlin wrote:
> 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".
Do the table names contain upper case letters? Then you must quote them,
like: SELECT * FROM "tableName";
Perhaps this helps a bit?
Christof Glaser
--
gl.aser . software engineering . internet service
http://gl.aser.de/ . Planckstraße 7 . D-39104 Magdeburg
From: | "Michael Coughlin" <MPCoughlin4(at)Home(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: error: Relation 'tableName' does not exist ? |
Date: | 2001-11-05 15:41:04 |
Message-ID: | 9s6bnt$2uck$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
ah Ha ! ... upper case letters ? ... so, THAT's it ?
Late last night, using pgAccess, I noticed that quoting the field names and
table name got things to work. I was wondering why sometimes it worked
without the quotes?
I have the new Wrox book, "Beginning PostgreSQL" arriving, today. I'm
hoping that it will fill in these subtleties, that I didn't notice in the
on-line docs.
THANKs, Christof - for taking a moment - to point that out.
Mike Coughlin