| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Andriy Pyrozhenko" <andriy(dot)pyrozhenko(at)vanjaonline(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Question |
| Date: | 2001-11-23 07:33:49 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOCEINCAAA.chriskl@familyhealth.com.au |
| 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;
My ALTER TABLE statement above will do exactly this.
It will delete activities when a job is deleted. Try it in a test database.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andriy Pyrozhenko | 2001-11-23 07:55:13 | Re: Question |
| Previous Message | Andrew G. Hammond | 2001-11-23 07:29:25 | Re: How to return more than one row of data from a function in PL/pgSQL |