Re: something similar to "on delete cascade" ?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: something similar to "on delete cascade" ?
Дата
Msg-id 200206281433.31804.josh@agliodbs.com
обсуждение исходный текст
Ответ на something similar to "on delete cascade" ?  ("Albrecht Berger" <berger1517@gmx.ch>)
Список pgsql-sql
Berger,

> My problem is that i don't want to delete datarows, but to set a "deleted"
> flag.
> In every by a foreign key "linked" row should this deleted flag set
> automatically.

You need to create a custom TRIGGER or RULE.  The online docs have extensive
instructions and examples of triggers and rules.

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology     josh@agliodbs.com   and data management solutions     (415) 565-7293  for law firms, small
businesses     fax 621-2533   and non-profit organizations.     San Francisco 





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

Предыдущее
От: Jie Liang
Дата:
Сообщение: Re: pg_restore cannot restore function
Следующее
От: Kelly
Дата:
Сообщение: pg_group members