Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitionning + Trigger and Execute not working as expected - Mailing list pgsql-sql

From Josh Kupershmidt
Subject Re: Partitionning + Trigger and Execute not working as expected
Date
Msg-id CAK3UJRErzuGFQQOx0FzZV72dDdLBfd1P4baOD-Jmb2PF7AsCFQ@mail.gmail.com
Whole thread Raw
In response to Re: Partitionning + Trigger and Execute not working as expected  (Sylvain Mougenot <smougenot@sqli.com>)
Responses Re: Partitionning + Trigger and Execute not working as expected  (Sylvain Mougenot <smougenot@sqli.com>)
List pgsql-sql
Tree view 
On Tue, Nov 8, 2011 at 11:04 AM, Sylvain Mougenot <smougenot@sqli.com> wrote:
> EXECUTE 'INSERT INTO '|| currentTableName || ' values (NEW.*)';

The quotes in the above line are wrong; you want it like:

EXECUTE 'INSERT INTO '|| currentTableName || ' values ' || (NEW.*);

Josh

pgsql-sql by date:

Previous
From: Ross Reedstrom
Date:
Subject: Re: help with xpath namespace
Next
From: tlund79
Date:
Subject: Re: Issue with a variable in a function