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

Re: Problem:Row Versioning with multiple field Primary Key

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem:Row Versioning with multiple field Primary Key
Date: 2001-07-30 14:57:37
Message-ID: Pine.LNX.4.21.0107301753050.16618-100000@nanu.visionforisrael.com (view raw or flat)
Thread:
Lists: pgsql-odbc
From the reference manual:

REFERENCES Constraint 

[ CONSTRAINT constraint_name ] REFERENCES reftable [ ( refcolumn ) ] 
    [ MATCH matchtype ]
    [ ON DELETE action ] 
    [ ON UPDATE action ]
    [ [ NOT ] DEFERRABLE ] 
    [ INITIALLY checktime ]

The refcolumn doesn't need to be the primary key.  Do you just want to
have referential integrity between your two (or more) unique fields (the
ones you originally used as the primary key) and some other table(s)?

-Cedar

On Mon, 30 Jul 2001, DI Hasenöhrl wrote:

> 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
> 


In response to

Responses

pgsql-odbc by date

Next:From: Cedar CoxDate: 2001-07-30 15:59:49
Subject: Re: Problem:Row Versioning with multiple field Primary Key
Previous:From: DI HasenöhrlDate: 2001-07-30 11:23:35
Subject: Problem:Row Versioning with multiple field Primary Key

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