Re: referential integrity constraints not checked inside - Mailing list pgsql-general

From James M Moe
Subject Re: referential integrity constraints not checked inside
Date
Msg-id 40A393AD.6080506@sohnen-moe.com
Whole thread Raw
In response to referential integrity constraints not checked inside PL/pgSQL functions?  (Christian Rank <christian.rank@rz.uni-passau.de>)
List pgsql-general
Christian Rank wrote:
>
>     create table a (n integer);
>     create table b (n integer);
>     alter table a add primary key (n);
>     alter table b add foreign key (n) references a(n);
>
Have you considered using "on delete cascade" in table b?

--
jimoe at sohnen-moe dot com

pgsql-general by date:

Previous
From: Christian Rank
Date:
Subject: Re: referential integrity constraints not checked inside
Next
From: "Jeffrey W. Baker"
Date:
Subject: Re: pg_xlog becomes extremely large during CREATE INDEX