How to combine multiple field primary key and Row Versioning

Поиск
Список
Период
Сортировка
От DI Hasenöhrl
Тема How to combine multiple field primary key and Row Versioning
Дата
Msg-id 003401c0fe2b$f72accc0$01011eac@irina
обсуждение исходный текст
Список pgsql-odbc
Hello,
 
I use Postgrsql 7.0.2 and ODBC 7.1.003. I discovered, that Row Versioning doesn't work with multiple field primary keys.
I need Row Versioning to be able to change tuples of a table, inserted by a function and I use multiple field primary keys to be sure, that inserted data are correct ie table *sortiment* contains the articles of each year
create table sortiment(
    year        integer,
    article_nr integer,
    number    integer,
    primary key(year,article_nr)
);
 
Are there further releases, which can combine multiple field primary keys and Row Versioning, or does anyone have any ideas, how to solve this confict?
 
Thanks in advance for any hint
Irina
 

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

Предыдущее
От: Dave Page
Дата:
Сообщение: RE: OLE DB access to PostgreSQL
Следующее
От: Olivier Berger
Дата:
Сообщение: Quick HOWTO - connecting StarOffice Win or Lin to PostGreSQL using ODBC