Thread: Cannot INDEX an Access97 ODBC export?
Exported a test table to a new PostgreSQL 7.0 database from Access97 via the PostgreSQL ODBC Driver v6.50.00000.
Went to /usr/local/pgsql/bin and executed the "psql database_name" and attempted to create a new index. ie;
CREATE INDEX test_idx ON table_name ( any_column_name );
Error return is that it is not able to find the attribute "any_column_name" in the table.
But..... If you build the table manually via "psql" then it can be indexed just fine.
Any ideas - Could this be a minor compatibility issue?
Reason for the question.... MySQL does not display this quirk.
> 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