Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporal foreign keys - Mailing list pgsql-general

From Jeff Davis
Subject Re: Temporal foreign keys
Date
Msg-id 1331848387.26127.33.camel@sussancws0025
Whole thread Raw
In response to Temporal foreign keys  (Matthias <nitrogenycs@googlemail.com>)
Responses Re: Temporal foreign keys  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
Tree view 
On Fri, 2012-02-03 at 07:58 +0100, Matthias wrote:
> Hey,
>
> how can I implement temporal foreign keys with postgresql? Is writing
> triggers the only way to enforce temporal referential integrity
> currently?

Yes, currently that's the only way. Look at CREATE CONSTRAINT TRIGGER.

Regards,
    Jeff Davis

pgsql-general by date:

Previous
From: Ben Schalley
Date:
Subject: Commit hits time-out before CommandTimeout
Next
From: Filip Rembiałkowski
Date:
Subject: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?