Re: Cannot open table in new database

On 07/01/2010 09:46 AM, Phil Jackson wrote:
> 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
>

Using mixed case :)

See here for gotchas of using mixed case:

http://www.postgresql.org/docs/8.4/interactive/sql-syntax-lexical.html
4.1.1. Identifiers and Key Words

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com