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

From Josh Berkus
Subject Re: something similar to "on delete cascade" ?
Date
Msg-id 200206281433.31804.josh@agliodbs.com
Whole thread Raw
In response to something similar to "on delete cascade" ?  ("Albrecht Berger" <berger1517@gmx.ch>)
List 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 by date:

Previous
From: Jie Liang
Date:
Subject: Re: pg_restore cannot restore function
Next
From: Kelly
Date:
Subject: pg_group members