> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
