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.