Re: Question of using trigger's OLD in EXECUTE

Thank you Sam!!
The code in the posting solves my issue. :)

Nim

On 10/23/2009 12:07 PM, Sam Mason wrote:
> 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
>