From: Andriy Pyrozhenko <andriy.pyrozhenko@vanjaonline.com>
To: pgsql-sql@postgresql.org
Subject: Re: Question
Date: Fri, 23 Nov 2001 09:55:13 +0200
Message-ID: <1424171808.20011123095513@vanjaonline.com> (raw)
In-Reply-To: <GNELIHDDFBOCMGBFGEFOCEINCAAA.chriskl@familyhealth.com.au>
References: <GNELIHDDFBOCMGBFGEFOCEINCAAA.chriskl@familyhealth.com.au>
Hello Christopher,
>> I don't need delete record from jobs when I delete record from
>> activity. But I need delete record from activity when I delete the
>> record from jobs and I need to find this job_id in activities table!
>> What must I do?
>>
>> CKL> Question: Why don't you just set up a foreign key that will
>> achieve exactly
>> CKL> the same thing without using RULEs?
>>
>> CKL> ie. ALTER TABLE activities ADD FOREIGN KEY (job_id)
>> REFERENCES jobs(job_id)
>> CKL> ON DELETE CASCADE;
CKL> My ALTER TABLE statement above will do exactly this.
CKL> It will delete activities when a job is deleted. Try it in a test database.
But also need delete activities!
--
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: Question
In-Reply-To: <1424171808.20011123095513@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