Re: Question of using trigger's OLD in EXECUTE

Поиск
Список
Период
Сортировка
Искать
От
Sam Mason
Тема
Re: Question of using trigger's OLD in EXECUTE
Дата
Msg-id
20091023160719.GH5407@samason.me.uk
Ответ на
Question of using trigger's OLD in EXECUTE (Nim Li)
Список
Дерево обсуждения
Incompatible library : Missing Magic Block <A.Bhattacharya@sungard.com>
Question of using trigger's OLD in EXECUTE Nim Li <nimli@sri.utoronto.ca>
Re: Question of using trigger's OLD in EXECUTE Sam Mason <sam@samason.me.uk>
Re: Question of using trigger's OLD in EXECUTE Nim Li <nimli@sri.utoronto.ca>
Re: Incompatible library : Missing Magic Block "Massa, Harald Armin" <chef@ghum.de>
Re: Incompatible library : Missing Magic Block Craig Ringer <craig@postnewspapers.com.au>
Re: Incompatible library : Missing Magic Block Merlin Moncure <mmoncure@gmail.com> 
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/
В списке pgsql-general по дате отправления
Предыдущее
От: Joshua Berry
Дата:
Следующее
От: Joshua Berry
Дата:
FAQ