Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 6098C47749E for ; Fri, 28 Jun 2002 17:41:30 -0400 (EDT) Mailbox-Line: From josh@agliodbs.com Fri Jun 28 17:41:30 2002 Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 7F7BC476200 for ; Fri, 28 Jun 2002 17:31:08 -0400 (EDT) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1560951; Fri, 28 Jun 2002 14:31:08 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "Albrecht Berger" , "pgsql" Subject: Re: something similar to "on delete cascade" ? Date: Fri, 28 Jun 2002 14:33:31 -0700 X-Mailer: KMail [version 1.4] References: <012201c21edd$2a992340$a07ba8c0@wxp> In-Reply-To: <012201c21edd$2a992340$a07ba8c0@wxp> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200206281433.31804.josh@agliodbs.com> X-Spam-Status: No, hits=-3.5 required=5.0 tests=IN_REP_TO,SUBJ_ENDS_IN_Q_MARK version=2.30 X-Spam-Level: X-Archive-Number: 200206/407 X-Sequence-Number: 8372 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 extensiv= e=20 instructions and examples of triggers and rules. --=20 -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco