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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to