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