[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    [SQL] constraint/restrict
From:       Olaf Marc Zanger <olaf.zanger () soli-con ! com>
Date:       2001-02-14 8:02:54
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]