Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA56280 for ; Tue, 5 Oct 1999 10:36:26 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA10928; Tue, 5 Oct 1999 10:34:47 -0400 (EDT) To: F.Makesch@sbe-zeta.de cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] 2 Aktions in a Rule In-reply-to: Your message of Tue, 5 Oct 1999 10:43:59 +0200 <99100510500800.05539@pinguin> Date: Tue, 05 Oct 1999 10:34:47 -0400 Message-ID: <10926.939134087@sss.pgh.pa.us> From: Tom Lane Florian Makesch writes: > 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? There's nothing wrong with that syntax AFAICS. Furthermore, my copy of Postgres takes it just fine (both 6.5.2 and current sources). I suspect you compiled with a buggy version of yacc or bison. Postgres' grammar is large and complex enough that it tends to expose problems in vendor-supplied yaccs :-(. Try getting a recent GNU bison (let's see ... I have 1.25 installed here, it's probably not the latest) and rebuilding. regards, tom lane