Re: Cannot INDEX an Access97 ODBC

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cannot INDEX an Access97 ODBC
Дата
Msg-id 19808.960572993@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Cannot INDEX an Access97 ODBC  (<lampe@durawebs.com>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: Cannot INDEX an Access97 ODBC
Следующее
От: "Steve Wolfe"
Дата:
Сообщение: Ah, yet another cause for not binding the right port....