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

2013-01-02 Thread Ali Pouya
2013/1/2 Pavel Stehule > 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 wor

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

2013-01-02 Thread Pavel Stehule
Hello 2013/1/2 Ali Pouya : > Hi all, > > The SQL file joined here reproduces the simplified version of a problem that > I encounter when trying to use the "NEW" record in an EXECUTE command within > a PL/PgSql trigger function. > > In this script the commented INSERT command works fine but the E

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

2013-01-02 Thread Ali Pouya
Hi all, The SQL file joined here reproduces the simplified version of a problem that I encounter when trying to use the "NEW" record in an EXECUTE command within a PL/PgSql trigger function. In this script the commented INSERT command works fine but the EXECUTE commande returns the following erro