The Rule does not working. - Mailing list pgsql-general

From King King
Subject The Rule does not working.
Date
Msg-id afggmd$en759@imsp212.netvigator.com
Whole thread Raw
List pgsql-general
Dear All,

Please help. I create below Deleted Rule in Postgres 7.1.3. But it does not
working. Please Help. That mean when I delete the record but it does not
update the table by the update command.

CREATE RULE inv_so_delete1 AS ON DELETE TO inv_detail DO UPDATE so_info SET
l_invoice = 'f'::bool WHERE ((NOT (EXISTS (SELECT inv_detail.c_sorder FROM
inv_detail WHERE (inv_detail.c_sorder = old.c_sorder)))) AND
(so_info.c_sorder = old.c_sorder));

Thanks

King King



pgsql-general by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: Acessing columns of parent tables with PL/pgSQL
Next
From: Carl Meyer
Date:
Subject: recursing down a tree