| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | mailing(dot)lists(at)octgsoftware(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ON DELETE CASCADE Question |
| Date: | 2013-11-04 19:55:45 |
| Message-ID: | 5277FBC1.2020403@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/04/2013 11:44 AM, Jason Long wrote:
> I would like for corresponding records in t_a to be deleted when I
> delete a record from t_b. This deletes from t_b when I delete from t_a,
> but not the other way around. I am unable to create a foreign key
> constraint on t_a because this table holds records from several other
> tables.
I am not sure how this is a problem? If you propose to delete a value
from t_a and that value is used by other tables how is the manner of its
deletion relevant?
I added a simple script below that demonstrates my problem.
>
> Any suggestions?
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-11-04 20:01:58 | Re: ON DELETE CASCADE Question |
| Previous Message | Adrian Klaver | 2013-11-04 19:48:04 | Re: table lock when where clause uses unique constraing instead of primary key. |