Cannot open table in new database

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

Responses

Browse pgsql-general by date

  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?