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

[Ali Pouya]

2013/1/2 Pavel Stehule <pavel.steh...@gmail.com>

> 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;