Re: Triggers and User Defined Trigger Functions

From: Gordan Bobic <gordan(at)bobich(dot)net>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Triggers and User Defined Trigger Functions
Date: 2005-03-09 15:09:13
Message-ID: 422F1199.5080903@bobich.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alessandro Vincelli 2005-03-09 15:49:28 Not use index on setof from Sql Function
Previous Message Csaba Nagy 2005-03-09 15:02:50 Re: Triggers and User Defined Trigger Functions