Re: Triggers and User Defined Trigger Functions

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Gordan Bobic <gordan(at)bobich(dot)net>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Triggers and User Defined Trigger Functions
Date: 2005-03-09 15:02:50
Message-ID: 1110380570.2838.49.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gordan Bobic 2005-03-09 15:09:13 Re: Triggers and User Defined Trigger Functions
Previous Message Tom Lane 2005-03-09 14:58:35 Re: Can't start PostgreSQL on Fedora Core3