From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | "A(dot) R(dot) Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: new rule syntax? |
Date: | 2006-02-06 09:49:19 |
Message-ID: | 43E71B9F.5090207@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
A. R. Van Hook wrote:
> I have two tables defined as:
> checks
> (ckid int NOT null PRIMARY KEY,
> payto text,
> notes text,
> ckdate date,
> printed int default 0,
> tdate timestamp not null)
> checkitems
> (item int not null,
> ckid int NOT null references checks,
> itemtype int not null,
> amt numeric(7,3),
> primary key (item, ckid))
>
> in previous versions (<8.1) the following rule declaration seemed to
> work fine
Others have addresses your query with the rule. Can I ask why you're not
using a DELETE CASCADE on the fkey?
...
ckid int NOT null references checks ON DELETE CASCADE,
...
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Josep Sanmartí | 2006-02-06 10:48:06 | Re: Trigger on a column |
Previous Message | Josep Sanmartí | 2006-02-06 09:44:12 | Trigger on a column |