Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 40AD8476227
	for <pgsql-sql@postgresql.org>; Fri, 28 Jun 2002 16:14:59 -0400 (EDT)
Mailbox-Line: From berger1517@gmx.ch  Fri Jun 28 16:14:59 2002
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id 388584761A0
	for <pgsql-sql@postgresql.org>; Fri, 28 Jun 2002 15:49:19 -0400 (EDT)
Received: (qmail 15593 invoked by uid 0); 28 Jun 2002 19:49:15 -0000
Received: from pd9e0d4df.dip.t-dialin.net (HELO wxp) (217.224.212.223)
	by mail.gmx.net (mp004-rz3) with SMTP; 28 Jun 2002 19:49:15 -0000
Message-ID: <012201c21edd$2a992340$a07ba8c0@wxp>
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
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Status: No, hits=0.3 required=5.0
	tests=SUBJ_ENDS_IN_Q_MARK,FROM_ENDS_IN_NUMS version=2.30
X-Spam-Level: 
X-Archive-Number: 200206/404
X-Sequence-Number: 8369

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