Re: Question of using trigger's OLD in EXECUTE - Mailing list pgsql-general

On Fri, Oct 23, 2009 at 11:27:11AM -0400, Nim Li wrote:
> CREATE OR REPLACE FUNCTION cp_tbl() RETURNS TRIGGER AS $proc$
>    BEGIN
>       EXECUTE 'INSERT INTO ' ||
>       TG_ARGV[0]             ||
>       ' SELECT '             ||
>       OLD;
>       RETURN NEW;
>    END;
> $proc$ LANGUAGE plpgsql;
>
> At run-time, it prompts an error:

> Does anyone have any idea how to fix it?

You need to quote your literals! :) The details are a bit fiddly, but
the following thread covered similar things recently:

  http://archives.postgresql.org/pgsql-general/2009-09/msg01176.php

--
  Sam  http://samason.me.uk/