something similar to "on delete cascade" ? - Mailing list pgsql-sql

From Albrecht Berger
Subject something similar to "on delete cascade" ?
Date
Msg-id 012201c21edd$2a992340$a07ba8c0@wxp
Whole thread Raw
Responses Re: something similar to "on delete cascade" ?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Hello,
I need something similar to the "on delete cascade" statement which
doesn't "listen" to the deletion of a row, but to a change of a column.

Do something like that exist ?

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.

Thx
berger





pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: pg_restore cannot restore function
Next
From: Jie Liang
Date:
Subject: Re: pg_restore cannot restore function