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
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Wed, 14 Feb 2001, Olaf Marc Za
From: "Olaf Marc Zanger" <[EMAIL PROTECTED]>
> hi there,
>
> with two tables i want to make some constraint-restrictions
>
> 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 b
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, ...
co
