Re: Cannot open table in new database

Hi Adrian

The link says that;

"Identifier and key word names are case insensitive."

But I have renamed the source table in lowercase and this gets me one
step further.

I'll carry on and see what happens next.

Cheers

Phil Jackson

On 6/30/2010 3:18 PM, Adrian Klaver wrote:
> 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
>
>