Re: [GENERAL] Cannot INDEX an Access97 ODBC export?

2000-06-09 Thread Bryan White
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

Re: [GENERAL] Cannot INDEX an Access97 ODBC

2000-06-09 Thread lampe
the imported column (name/attribute)... wierd? Dlampe [EMAIL PROTECTED] - Original Message - From: Bryan White [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 09, 2000 3:39 PM Subject: Re: [GENERAL] Cannot INDEX an Access97 ODBC export? Error return

Re: [GENERAL] Cannot INDEX an Access97 ODBC

2000-06-09 Thread Tom Lane
[EMAIL PROTECTED] writes: The psql CREATE INDEX statement can't see the imported column (name/attribute)... wierd? I still think that Bryan's got the right idea --- Access probably created the column name with some embedded blanks and/or upper-case characters, which'd mean that you have to