Received: from webmail.parks.lv (mail@smtp.parks.lv [195.2.96.248]) by hub.org (8.10.1/8.10.1) with ESMTP id e7FECfn79532 for ; Tue, 15 Aug 2000 10:12:41 -0400 (EDT) Received: from SANDIS ([195.2.123.209]) by webmail.parks.lv (8.9.3/8.9.3) with ESMTP id QAA10403; Tue, 15 Aug 2000 16:12:01 +0200 Date: Tue, 15 Aug 2000 16:12:53 +0300 From: Sandis X-Mailer: The Bat! (v1.41) X-Priority: 3 (Normal) Message-ID: <0675.000815@parks.lv> To: Jesus Aneiros CC: pgsql-sql@postgresql.org Subject: Re[2]: data integrity Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/109 Hello Jesus, Tuesday, August 15, 2000, 4:04:40 PM, you wrote: JA> The solution is called referential integrity. you should use the foreign JA> key and references clause with cascade. >> can someone suggest some good online resource where such common sql topics >> discussed? JA> I would like to know such a place. JA> Jesus. Thank you. I found what i need about referential integrity here http://www.postgresql.org/mhonarc/pgsql-general/1999-08/msg00474.html ye,in Access it needed to check 1 checkbox, but here one should write some code.. --:)-- Best regards, Sandis mailto:sandisj@parks.lv