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/