Received: from viking.relc.com (viking.relc.com [193.124.229.195]) by hub.org (8.9.3/8.9.3) with SMTP id GAA25632 for ; Tue, 5 Oct 1999 06:41:21 -0400 (EDT) (envelope-from sbon@scelto.ts.kiev.ua) Received: from scelto.ts.kiev.ua by viking.relc.com with ESMTP id NAA03341; (8.8.8/zah/2.1) Tue, 5 Oct 1999 13:32:11 +0300 (EET DST) Received: from goth.ts.kiev.ua by scelto.ts.kiev.ua with ESMTP id NAA71601; (8.8.8/zah/2.1) Tue, 5 Oct 1999 13:31:04 +0300 (EEST) Message-ID: X-Mailer: XFMail 1.3 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <99100510500800.05539@pinguin> Date: Tue, 05 Oct 1999 13:31:04 +0300 (EEST) Organization: Relcom-Ukraine Sender: sbon@goth.ts.kiev.ua From: Sergey Bondarenko To: pgsql-sql@postgresql.org Subject: RE: [SQL] 2 Aktions in a Rule I have the same problem. Dox says that multiple actions are permitted on a single rule. But it won't work. I do not know why. On 05-Oct-99 Florian Makesch wrote: > Hello, > I hope someone can help me. I Want 2 Aktions executeed in a Rule like: > CREATE RULE auftraege_neu_delete AS ON delete > TO auftraege_neu DO > (DELETE FROM auftraege_neu_positionen > WHERE auftraege_neu_positionen.auftragsnr = OLD.auftragsnr; > DELETE FROM auftraege_neu_zubehoer > WHERE auftraege_neu_zubehoer.auftragsnr = OLD.auftragsnr;); > but I get a Parser Error: > ERROR: parser: parse error at or near "" > This is in PostgreSQL 6.5.2 > > Has anyone the correct syntax? > > regards > Florian > > > ************ Sergey Bondarenko Relcom-Ukraine system administrator