Re: Using the NEW record in an EXECUTE command in a PL/pgSQL trigger function

[Ali Pouya <alipouya2@xxxxxxxxx>]

2013/1/2 Pavel Stehule <pavel.stehule@xxxxxxxxx>

you forgot USING clause

BEGIN
        EXECUTE 'INSERT INTO measurement1 values(new.*)' USING new;
--        INSERT INTO measurement1 values(new.*);
        RETURN NULL;
END;

Regards

Pavel Stehule

 Hi Pavel,
Thanks for your answer, but it did not work for me (I test on versions 9.1.6 and 9.2.1).

Fortunately I found this solution in the archives :

EXECUTE 'INSERT INTO measurement1 select $1.* ' USING new;