From: | Andriy Pyrozhenko <andriy(dot)pyrozhenko(at)vanjaonline(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Question |
Date: | 2001-11-23 07:55:13 |
Message-ID: | 1424171808.20011123095513@vanjaonline.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)pyrozhenko(at)vanjaonline(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Bertheau | 2001-11-23 07:55:22 | Re: Joins~ |
Previous Message | Christopher Kings-Lynne | 2001-11-23 07:33:49 | Re: Question |