Re: Cannot INDEX an Access97 ODBC - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot INDEX an Access97 ODBC
Date
Msg-id 19808.960572993@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cannot INDEX an Access97 ODBC  (<lampe@durawebs.com>)
List pgsql-general
<lampe@durawebs.com> 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 quote the column name in
order to refer to it.

It would be useful to see the output of
     pg_dump -s -t tablename databasename
for this table.

            regards, tom lane

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Cannot INDEX an Access97 ODBC
Next
From: "Steve Wolfe"
Date:
Subject: Ah, yet another cause for not binding the right port....