Re: Partitionning + Trigger and Execute not working as expected

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Sylvain Mougenot <smougenot(at)sqli(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Partitionning + Trigger and Execute not working as expected
Date: 2011-11-09 00:35:31
Message-ID: CAK3UJRErzuGFQQOx0FzZV72dDdLBfd1P4baOD-Jmb2PF7AsCFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Nov 8, 2011 at 11:04 AM, Sylvain Mougenot <smougenot(at)sqli(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message tlund79 2011-11-09 08:32:12 Re: Issue with a variable in a function
Previous Message Ross Reedstrom 2011-11-08 22:59:37 Re: help with xpath namespace