Re: Delete with join -- deleting related table entries? - Mailing list pgsql-sql

From Bryce Nesbitt
Subject Re: Delete with join -- deleting related table entries?
Date
Msg-id 43EA2B62.8070504@obviously.com
Whole thread Raw
In response to Re: Delete with join -- deleting related table entries?  ("BigSmoke" <bigsmoke@gmail.com>)
List pgsql-sql
BigSmoke wrote:
> ...I'd usually do this by using
>   issue_id INTEGER REFERENCES issue ON DELETE CASCADE
>   
Good, and valuable, thanks!

But at the moment I can't change the schema.  So is there a way to do a
cascaded or joined delete
in a sql schema that did not anticipate it?  Again, this is deleting
rows from three related tables, as a single atomic operation.
                                                      -Bryce


pgsql-sql by date:

Previous
From: "Owen Jacobson"
Date:
Subject: Re: Delete with join -- deleting related table entries?
Next
From: "Owen Jacobson"
Date:
Subject: Re: Delete with join -- deleting related table entries?