RE: [GENERAL] Newbie Questions, PostgreSQL
Taral <taral@mail.utexas.edu>
From: "Taral" <taral@mail.utexas.edu>
To: "Sze Yuen Wong" <swong_@yahoo.com>, <pgsql-general@postgreSQL.org>
Date: 1998-10-15T18:30:34Z
Lists: pgsql-general
> 1.What is wrong with the following PostgreSQL statement? > > CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values > (new.i); > NOTIFY TBL2]; > > I got the following error messages following its execution: > > ERROR: parser: parse error at pr near "" > ERROR: parser: parse error at pr near "]" You want " and ", not [ and ]. And you will need to specify LANGUAGE "SQL" as well, I think. Taral