Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.mailgate.org!newsfeed.wirehub.nl!newsfeed00.sul.t-online.de!t-online.de!inka.de!not-for-mail
From: "Felix E. Klee" <felix.klee@inka.de>
Newsgroups: comp.databases.theory
Subject: Re: How to ensure data consistency?
Date: Thu, 9 Sep 2004 01:54:43 +0200
Organization: (Posted via) INKA e.V. http://www.inka.de/
Lines: 11
Message-ID: <20040909015443.7bcdede7.felix.klee@inka.de>
References: <chmjpb$kl6@odbk17.prod.google.com>
NNTP-Posting-Host: puric.inka.de
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Trace: sapa.inka.de 1094687943 17326 193.197.184.17 (8 Sep 2004 23:59:03 GMT)
X-Complaints-To: abuse@inka.de
NNTP-Posting-Date: 8 Sep 2004 23:59:03 GMT
X-Newsreader: Sylpheed version 0.9.9 (GTK+ 1.2.10; i486-slackware-linux-gnu)
Xref: dp-news.maxwell.syr.edu comp.databases.theory:25877

On 8 Sep 2004 02:35:39 -0700 Tony Andrews wrote:
> As Dan says elsewhere, the 2-way foreign keys will work if your DBMS
> allows constraint checking to be deferred until you commit the
> transaction:
>
> [...]

Thanks. Similar code worked fine (in posgreSQL). As a newbie to
databases I didn't know this simple solution.

Felix