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@durawebs.com
----- Original Message -----
From: Bryan White <bryan@arcamax.com>
To: <lampe@durawebs.com>; <pgsql-general@postgresql.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
>
>