Re: Triggers and User Defined Trigger Functions - Mailing list pgsql-general

> DELETE FROM Temp1 WHERE Test = 'test3';
> ERROR:  syntax error at or near "$2" at character 44
> QUERY:  INSERT INTO Temp2 (ID, test) VALUES ( $1   $2 )
> CONTEXT:  PL/pgSQL function "temp1_trigger_delete" line 2 at SQL statement
> LINE 1: INSERT INTO Temp2 (ID, test) VALUES ( $1   $2 )
                                                  ^^^
>
> What did I miss?

A comma in the indicated position I guess...

HTH,
Csaba.