Re: Cannot INDEX an Access97 ODBC

From: <lampe(at)durawebs(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot INDEX an Access97 ODBC
Date: 2000-06-09 11:13:52
Message-ID: 008301bfd203$cb2508c0$79f63ed8@UNIXSERVER
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for the response:

The column exists in the table structure and can be accessed/queried via
psql with SELECT statements or via ODBC SELECT statements form Access97.
The data intergrity (content) for the table and columns is fine and intact.
The psql CREATE INDEX statement can't see the imported column
(name/attribute)... wierd?

Dlampe
lampe(at)durawebs(dot)com

----- Original Message -----
From: Bryan White <bryan(at)arcamax(dot)com>
To: <lampe(at)durawebs(dot)com>; <pgsql-general(at)postgresql(dot)org>
Sent: Friday, June 09, 2000 3:39 PM
Subject: Re: [GENERAL] Cannot INDEX an Access97 ODBC export?

>
> > Error return is that it is not able to find the attribute
> "any_column_name" in the table.
>
> This maybe obvious but have you looked at the table layout to see if the
> column exists. You may have a problem with spaces in the name or upper
case
> letters in the name. In either case you must quote the name (table or
> column). Un quoted names are converted to all lower case.
>
> In psql do: \d tablename
> or from the shell do: pg_dump -s -t tablename
>
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-06-09 12:38:03 Re: UESQLC
Previous Message Koujiro Iuchi 2000-06-09 10:41:59 Re: pgaccess problem on Solaris OS.