Re: Temporal foreign keys

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Matthias <nitrogenycs(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporal foreign keys
Date: 2012-03-15 21:53:07
Message-ID: 1331848387.26127.33.camel@sussancws0025
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug Gorley 2012-03-15 23:09:32 Zero-length character breaking query?
Previous Message Steve Crawford 2012-03-15 21:27:29 Re: undo update