From: Andriy Pyrozhenko <andriy.pyrozhenko@vanjaonline.com>
To: pgsql-sql@postgresql.org
Subject: Re: Rule
Date: Tue, 20 Nov 2001 17:31:37 +0200
Message-ID: <6331217468.20011120173137@vanjaonline.com> (raw)
In-Reply-To: <29543.1006269869@sss.pgh.pa.us>
References: <7524444939.20011120153845@vanjaonline.com>
<29543.1006269869@sss.pgh.pa.us>
Hello Tom,
Tuesday, November 20, 2001, 5:24:29 PM, you wrote:
TL> 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.
TL> I think you're going to need to use a trigger, instead. The
TL> rule-generated query runs first, and then by the time you get to the
TL> actual DELETE FROM jobs, the SELECT DISTINCT subquery doesn't find any
TL> rows ...
TL> regards, tom lane
How can I do it. I use PostgreSQL 7.1.3
Best regards,
Andriy mailto:andriy.pyrozhenko@vanjaonline.com
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: andriy.pyrozhenko@vanjaonline.com
Subject: Re: Rule
In-Reply-To: <6331217468.20011120173137@vanjaonline.com>
* 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