Re: Can i force deletion of dependent rows?

Поиск

Список

Период

Сортировка

От	Shoaib Mir
Тема	Re: Can i force deletion of dependent rows?
Дата	13 февраля 2010 г. 07:32:51
Msg-id	bf54be871002130332h6617b33ateb4dcef3d4213054@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Can i force deletion of dependent rows? ("Wayne E. Seguin" <wayneeseguin@gmail.com>)
Ответы	Re: Can i force deletion of dependent rows?
Список	pgsql-sql

Дерево обсуждения

On Sat, Feb 13, 2010 at 10:23 PM, Wayne E. Seguin <wayneeseguin@gmail.com> wrote:

Is there another answer, asside from in the application and/or as a
trigger using `DELETE FROM B WHERE z = 'x';` as it's body?

Did you look at ON DELETE CASCADE option, check out http://www.postgresql.org/docs/8.3/interactive/ddl-constraints.html

CREATE TABLE order_items (    product_no integer REFERENCES products ON DELETE RESTRICT,    order_id integer REFERENCES orders ON DELETE CASCADE,    quantity integer,    PRIMARY KEY (product_no, order_id)

);

--
Shoaib Mir
http://shoaibmir.wordpress.com/

В списке pgsql-sql по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: Can i force deletion of dependent rows?