Re: referential integrity constraints not checked inside

From: James M Moe <jimoe(at)sohnen-moe(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: referential integrity constraints not checked inside
Date: 2004-05-13 15:26:37
Message-ID: 40A393AD.6080506@sohnen-moe.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey W. Baker 2004-05-13 16:02:10 Re: pg_xlog becomes extremely large during CREATE INDEX
Previous Message Christian Rank 2004-05-13 14:19:17 Re: referential integrity constraints not checked inside