Re: Question

Andriy,

>   I have the rule for table
>   CREATE RULE del_jobs_del_activity AS ON DELETE TO jobs DO DELETE
> FROM activities WHERE job_id = OLD.job_id;
> 
>   When i call:
>   DELETE FROM jobs WHERE job_id IN (SELECT DISTINCT job_id FROM
> activities WHERE load_no = OLD.load_no)
>   This query does not delete the record from jobs but delete the
>   record by rule.

And this is a problem because ... ?

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco