Skip site navigation (1) Skip section navigation (2)

Problem:Row Versioning with multiple field Primary Key

From: DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Problem:Row Versioning with multiple field Primary Key
Date: 2001-07-30 11:23:35
Message-ID: 007a01c118ea$1309ae60$01011eac@irina (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,
I use postgresql 7.0.2 with ODBC 7.1.0003 as backend and MsAccess97 as frontend.
In order to be able to work with float and numeric values I must enable Row Versioning, but this only works with single field primary keys.
In my database design I use multiple field primary keys and also multiple field foreign keys.
For enabling Row Versioning I changed the multiple field Primary keys to a *dummy* single field primary key and created unique indexes but how can I realize referential integrity on these unique indexes???????????
I can imagine to handle referential integrity with triggers. Is there another, better solution for this problem?

Please, let me know where I can find some hints :-)
Kind regards
Irina

E-Mail: i(dot)hasenoehrl(at)aon(dot)at

Responses

pgsql-odbc by date

Next:From: Cedar CoxDate: 2001-07-30 14:57:37
Subject: Re: Problem:Row Versioning with multiple field Primary Key
Previous:From: JosephDate: 2001-07-30 11:06:44
Subject: S1002: Invalid column number in ColAttributes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group