> 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