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

From Adrian Klaver
Subject Re: Cannot open table in new database
Date
Msg-id 4C2BC2D3.3020002@gmail.com
Whole thread Raw
In response to Cannot open table in new database  (Phil Jackson <sapient@clear.net.nz>)
Responses Re: Cannot open table in new database
List pgsql-general
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.klaver@gmail.com

pgsql-general by date:

Previous
From: Phil Jackson
Date:
Subject: Cannot open table in new database
Next
From: Szymon Guz
Date:
Subject: loading many queries from a file