Received: from borg.3logic.net (borg.3logic.net [195.38.16.4]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAGBL2m22070 for ; Fri, 16 Nov 2001 06:21:03 -0500 (EST) (envelope-from andriy.pyrozhenko@vanjaonline.com) Received: (qmail 31278 invoked from network); 16 Nov 2001 13:21:03 +0200 Received: (qmail: 1.03); 16 Nov 2001 11:21:03 -0000 Received: from onetim.3logic.net (HELO mail.vanjaonline.com) (195.38.17.73) by borg.3logic.net with SMTP; 16 Nov 2001 13:21:02 +0200 Received: from PYROZHENKO ([192.168.1.10]) by mail.vanjaonline.com (WinRoute Pro 4.1.29) with SMTP; Fri, 16 Nov 2001 13:19:56 +0200 Date: Fri, 16 Nov 2001 13:19:51 +0200 From: Andriy Pyrozhenko X-Mailer: The Bat! (v1.53bis) Reply-To: Andriy Pyrozhenko X-Priority: 3 (Normal) Message-ID: <5711701906.20011116131951@vanjaonline.com> To: pgsql-sql@postgresql.org Subject: SQL MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/239 X-Sequence-Number: 5621 Hello , 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 = 123) This query does not delete the record from jobs but delete the record by rule. What must I change for work this query correctly? Best regards, Andriy mailto:andriy.pyrozhenko@vanjaonline.com