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

Csaba Nagy wrote:
>>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...

Thanks. I'm feeling really stupid now. You may all mock me. :-)
Thanks for your help, it's most appreciated. :-)

Gordan