Search Postgresql Archives

Cannot open table in new database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux