Received: from viking.relc.com (viking.relc.com [193.124.229.195]) by hub.org (8.9.3/8.9.3) with SMTP id DAA03540 for ; Wed, 6 Oct 1999 03:17:01 -0400 (EDT) (envelope-from sbon@scelto.ts.kiev.ua) Received: from scelto.ts.kiev.ua by viking.relc.com with ESMTP id JAA04120; (8.8.8/zah/2.1) Wed, 6 Oct 1999 09:59:39 +0300 (EET DST) Received: from goth.ts.kiev.ua by scelto.ts.kiev.ua with ESMTP id JAA54694; (8.8.8/zah/2.1) Wed, 6 Oct 1999 09:38:33 +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: <10926.939134087@sss.pgh.pa.us> Date: Wed, 06 Oct 1999 09:38:33 +0300 (EEST) Organization: Relcom-Ukraine Sender: sbon@goth.ts.kiev.ua From: Sergey Bondarenko To: Tom Lane Subject: Re: [SQL] 2 Aktions in a Rule Cc: pgsql-sql@postgresql.org, F.Makesch@sbe-zeta.de Yep. It works. I had the problem with 6.5.1 version both on RedHat 5.1 and FreeBSD 3.2 boxes. It runs just fine, when is built using bison-1.28 (available at ftp.gnu.org). Thanks all. On 05-Oct-99 Tom Lane wrote: > 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 > > ************ Sergey Bondarenko Relcom-Ukraine system administrator