On 2/1/06, Padam J Singh <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am maintaining an application that has over 400 procedures and functions
> written in plsql, and around 100 tables.
> I want to generate a function dependency chart to depict the following:
>
> 1. Inter function/procedure depend
Try this rule instead
create rule checks_d0 as
on delete to checks
do delete from checkitems
where ckid = OLD.ckid;
-- Original Message ---
From: "Milen A. Radev" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Sent: Sun, 05 Feb 2006 15:10:23 +0200
Subjec
A. R. Van Hook написа:
I have two tables defined as:
checks
(ckidint NOT null PRIMARY KEY,
payto text,
notes text,
ckdate date,
printed int default 0,
tdate timestamp
am 05.02.2006, um 6:00:18 -0600 mailte A. R. Van Hook folgendes:
> in previous versions (<8.1) the following rule declaration seemed to work
> fine
> create rule checks_d0 as
> on delete to checks
> do delete from checkitems
>where ckid = checks.ckid;
> in 8.1.2 I get
>
I have two tables defined as:
checks
(ckidint NOT null PRIMARY KEY,
payto text,
notes text,
ckdate date,
printed int default 0,
tdate timestamp not null)
checkitems
