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

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
>