Cannot INDEX an Access97 ODBC export?

From: <lampe(at)durawebs(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Cannot INDEX an Access97 ODBC export?
Date: 2000-06-09 10:01:56
Message-ID: 004301bfd1f9$beae0240$79f63ed8@UNIXSERVER
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message NRonayette 2000-06-09 10:05:53 Re: to pass a parameter
Previous Message jprem 2000-06-09 10:00:09 help on macro substitution