From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andriy Pyrozhenko <andriy.pyrozhenko@vanjaonline.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Rule
Date: Tue, 20 Nov 2001 10:24:29 -0500
Message-ID: <29543.1006269869@sss.pgh.pa.us> (raw)
In-Reply-To: <7524444939.20011120153845@vanjaonline.com>
References: <7524444939.20011120153845@vanjaonline.com>
Andriy Pyrozhenko <andriy.pyrozhenko@vanjaonline.com> writes:
> CREATE RULE del_jobs_del_activity AS ON DELETE TO jobs DO DELETE FROM activities WHERE job_id = OLD.job_id;
> 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.
I think you're going to need to use a trigger, instead. The
rule-generated query runs first, and then by the time you get to the
actual DELETE FROM jobs, the SELECT DISTINCT subquery doesn't find any
rows ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, andriy.pyrozhenko@vanjaonline.com
Subject: Re: Rule
In-Reply-To: <29543.1006269869@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox