Re: Storing "deleted" data
From: x <x_at_not-exists.org>
Date: Mon, 31 Oct 2005 11:10:39 +0200
Message-ID: <dk4n2j$ju9$1_at_domitilla.aioe.org>
Date: Mon, 31 Oct 2005 11:10:39 +0200
Message-ID: <dk4n2j$ju9$1_at_domitilla.aioe.org>
"x" <x_at_not-exists.org> wrote in message
news:dk4mo4$jib$1_at_domitilla.aioe.org...
>
> <zeldorblat_at_gmail.com> wrote in message
> news:1130700808.833451.143900_at_g43g2000cwa.googlegroups.com...
> > #2 Isn't too bad -- the table containing current data is smaller and
> > faster to update/select. But in this case I don't know how to define
> > the integrity constraints. As far as I know you can't have a foreign
> > key reference to one table OR another.
>
> a)You can split all tables in current/old.
> b)You can try to declare a foreign key reference FROM one table AND
another.
Received on Mon Oct 31 2005 - 10:10:39 CET