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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
