Cannot open table in new database - Mailing list pgsql-general

From Phil Jackson
Subject Cannot open table in new database
Date
Msg-id 4C2CC661.5050108@clear.net.nz
Whole thread Raw
Responses Re: Cannot open table in new database  (Adrian Klaver <adrian.klaver@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: LINE 1: IDENTIFY_SYSTEM error infinitum
Next
From: Adrian Klaver
Date:
Subject: Re: Cannot open table in new database