Re: Delete with join -- deleting related table entries?

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Delete with join -- deleting related table entries?
Date: 2006-02-08 17:33:22
Message-ID: 43EA2B62.8070504@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Owen Jacobson 2006-02-08 17:35:14 Re: Delete with join -- deleting related table entries?
Previous Message Owen Jacobson 2006-02-08 17:32:27 Re: Delete with join -- deleting related table entries?