From: Albrecht Berger <berger1517@gmx.ch>
To: pgsql <pgsql-sql@postgresql.org>
Subject: something similar to "on delete cascade" ?
Date: Fri, 28 Jun 2002 21:51:15 +0200
Message-ID: <012201c21edd$2a992340$a07ba8c0@wxp> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: berger1517@gmx.ch
Subject: Re: something similar to "on delete cascade" ?
In-Reply-To: <012201c21edd$2a992340$a07ba8c0@wxp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox