Re: [GENERAL] Temporal foreign keys

2012-03-17 Thread Simon Riggs
On Fri, Feb 3, 2012 at 6:58 AM, Matthias wrote: > how can I implement temporal foreign keys with postgresql? Is writing > triggers the only way to enforce temporal referential integrity > currently? I think you need to explain what you want slightly better. My guess would be you want this cr

Re: [GENERAL] Temporal foreign keys

2012-03-16 Thread Jeff Davis
On Fri, 2012-03-16 at 15:13 +0100, Andreas Kretschmer wrote: > > On Fri, 2012-02-03 at 07:58 +0100, Matthias wrote: > > > how can I implement temporal foreign keys with postgresql? Is writing > > > triggers the only way to enforce temporal referential integrity > > > currently? > > > It works in 9

Re: [GENERAL] Temporal foreign keys

2012-03-16 Thread Andreas Kretschmer
Jeff Davis wrote: > 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

Re: [GENERAL] Temporal foreign keys

2012-03-15 Thread Jeff Davis
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,

[GENERAL] Temporal foreign keys

2012-02-02 Thread Matthias
Hey, how can I implement temporal foreign keys with postgresql? Is writing triggers the only way to enforce temporal referential integrity currently? -Matthias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/m