X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7EFCA30EBC4 for ; Fri, 13 Jun 2003 13:57:40 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 36620-05 for ; Fri, 13 Jun 2003 10:57:30 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id D3AFF30EBA1 for ; Fri, 13 Jun 2003 10:57:29 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5DDvQU6000353; Fri, 13 Jun 2003 09:57:26 -0400 (EDT) To: "Albrecht Berger" Cc: "pgsql" Subject: Re: trigger : emulate "instead of" with before ? In-reply-to: <046801c331a2$0c483e70$a07ba8c0@wxp> References: <046801c331a2$0c483e70$a07ba8c0@wxp> Comments: In-reply-to "Albrecht Berger" message dated "Fri, 13 Jun 2003 13:50:54 +0200" Date: Fri, 13 Jun 2003 09:57:25 -0400 Message-ID: <352.1055512645@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/123 X-Sequence-Number: 13881 "Albrecht Berger" writes: > I need a trigger which is updating a delete flag of a row instead of > deleting it physically. > How do I implement a trigger which doesn't execute a delete without raising > an exception in plsql ? If the BEFORE DELETE trigger returns NULL, the delete is skipped. regards, tom lane