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