Re: Possible ODBC driver error

Here's one possibility...
Were the names mixed case? If so, the copied tables probably
were created with their names quoted and you'll need to quote
the names to reference them. Postgres lowercases unquoted
names (for case-insensitivity), so if you create a table with
something like:
create table "A" ...
the only way to reference the table is as "A" not A.

On Mon, 16 Apr 2001, Patrick Dunford wrote:

> I recently copied five tables to the server using the Postgres ODBC driver
> with MS Access.
>
> The tables can be viewed in MS Access but not using PHP or Zeos Database
> Explorer, which both return the same error message:
> ERROR: Relation 'adweb_servinf1' does not exist
>
> The tables are visible in ZDO and the column names can be viewed. All the
> names of the tables also appear in pg_tables.
>
> Is this a bug in the ODBC driver i.e. it does not make the full entries
> needed in Postgres for it to know about tables?