14 Feb
2001
14 Feb
'01
8:29 a.m.
hi there, i want to make some constraint-restrictions with two tables in postgres create table address ( id serial, country_id int4, ....); and create table country (id serial, ...); i want to make sure that the country-row with "id=2" is not deleted if there is still a corresponding data-set with "country_id=2" in the 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:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com