From: | Phil Jackson <sapient(at)clear(dot)net(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Cannot open table in new database |
Date: | 2010-07-01 16:46:25 |
Message-ID: | 4C2CC661.5050108@clear.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We've set up a Sql database for the first time and get an error reported
back to our application from the ODBC session object when we try to open
one of the tables.
[42p01][7]ERROR Relation "SqlAnal" does not exist; table not found!
Here is my database outline in the Admin tool
Servers(1)
Concept Patterns (localhost:5432)
Databases(1)
Postgres
casts
languages
schemas
Public
-
-
Tables(2)
DocHeader
SqlAnal
Replication
Tablespaces(2)
pg_default
pg_global
Group Roles
Login Roles(1)
Concept
We can access the list of tables from the ODBC driver which shows the
above tables.
We've obviously done something wrong but we don't know where to look.
The Help button is not helpful at all.
Any ideas on what we are doing incorrectly?
Cheers
Phil Jackson
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Christensen | 2010-07-01 16:47:03 | Re: Easy way to convert a database from WIN1252 to UTF8? |
Previous Message | Sam Mason | 2010-07-01 16:44:19 | Re: Easy way to convert a database from WIN1252 to UTF8? |