Received: from tom.oleane.net (root@tom.oleane.net [194.2.28.14]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA21471 for ; Tue, 16 Jun 1998 05:06:54 -0400 (EDT) Received: from renoir.asnieres.supranets.com (root@dialup-186.def.oleane.com [195.25.5.186]) by tom.oleane.net (8.8.8/8.8.8) with ESMTP id LAA29197 for ; Tue, 16 Jun 1998 11:06:51 +0200 Received: from ft.asnieres.supranets.com (ft [192.168.0.7]) by renoir.asnieres.supranets.com (8.8.5/8.8.5) with SMTP id LAA09922 for ; Tue, 16 Jun 1998 11:00:38 +0200 Reply-To: "Francois TETE" From: "Francois TETE" To: Subject: Rule "Delete" Date: Tue, 16 Jun 1998 11:02:39 +0200 Message-ID: <01bd9905$833337a0$0700a8c0@ft.asnieres.supranets.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Has anybody tried to use delete-rules with PostgreSQL 6.3 ? I have a table named "ifTable" with columns "id" and "ifType" with an index on "id". and a table named "profilTable" with column "id" and some other columns. Each time I insert a row in profilTable I want to insert a row in ifTable, so I created a rule : create rule r1 as on insert to profilTable do insert into ifTable values (new.id, 'profil'); I would like to automatically remove this entry in iftable when I delete the corresponding row in profilTable, but my rule does not work (nothings happens and/or the backend crashes after displaying : "copyObject : don't know how to copy XXX" ) : create rule r2 as on delete to profilTable do delete from ifTable where id=current.id; Could anybody help me ? --- François TETE SupraNETS 25 rue des Bas - 92600 Asnières - FRANCE Mail : francois.tete@supranets.com Phone: +33 1 46 88 09 69 Fax : +33 1 47 90 65 56