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

Поиск
Список
Период
Сортировка
От Bryce Nesbitt
Тема Re: Delete with join -- deleting related table entries?
Дата
Msg-id 43EA2B62.8070504@obviously.com
обсуждение исходный текст
Ответ на Re: Delete with join -- deleting related table entries?  ("BigSmoke" <bigsmoke@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Owen Jacobson"
Дата:
Сообщение: Re: Delete with join -- deleting related table entries?
Следующее
От: "Owen Jacobson"
Дата:
Сообщение: Re: Delete with join -- deleting related table entries?