Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1EHsYx64478 for ; Wed, 14 Feb 2001 12:54:35 -0500 (EST) (envelope-from jliang@tidal.ipinc.com) Received: from localhost (jliang@localhost) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id JAA63607; Wed, 14 Feb 2001 09:54:29 -0800 (PST) (envelope-from jliang@tidal.ipinc.com) Date: Wed, 14 Feb 2001 09:54:28 -0800 (PST) From: Jie Liang To: Olaf Marc Zanger cc: PgSQL-SQL Subject: Re: constraint/restrict In-Reply-To: <01021409023603.01358@sino> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200102/264 X-Sequence-Number: 1455 add an foriegn key on address(country_id), let country(id) be a primary key. Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.stbernard.com www.ipinc.com On Wed, 14 Feb 2001, Olaf Marc Zanger wrote: > hi there, > > with two tables i want to make some constraint-restrictions > > create table address ( id serial, country_id int4, ....); > and > create table country (id serial, ...); > > to make sure that now country-row is deleted if there is still a country_id > in address table. > > e.g. > > address: 1, 2, ... > country: 2, ... > > now country wouldn't be allowed to be deleted. > > how to do that? > > thanks fo help > > olaf > -- > soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger > Lorrainestrasse 23, 3013 Bern / Switzerland > fon:+41-31-332 9782, mob:+41-76-572 9782 > mailto:olaf.zanger@soli-con.com, http://www.soli-con.com >