Re: Access/Postgresql problem with text fields recognized as

Поиск
Список
Период
Сортировка
От laurie.burrow@powerconv.alstom.com
Тема Re: Access/Postgresql problem with text fields recognized as
Дата
Msg-id OFA38A69EB.ACA5861D-ON80256FA3.006450A4-80256FA3.00654C7F@transport.alstom.com
обсуждение исходный текст
Список pgsql-odbc
Justin Dahl wrote:

> All tables I create have a unique index called "id" that is of type
> "serial".
> Setting "Row Versioning" in odbc driver does not make any difference.

I have experienced the same general issue using Access (several versions)
and Postgres 8. I believe this issue is resolved by ensuring that you have
defined a primary key for the table. A unique field is not sufficient. I
have found that setting the row versioning option does not help.

Access will identify rows using the primary key of a linked table provided
it does not map to a memo field. I generally use a serial type which works
fine.

Hope this helps
Laurie


:.________________
CONFIDENTIALITY : This  e-mail  and  any attachments are confidential and
may be privileged. If  you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.



В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: FW: [pgsql-www] Thanks plus three observations & some questions
Следующее
От: "Dave Page"
Дата:
Сообщение: FW: postgresql & iodbc HOWTO document thoughts