Passing parameters to triggers

Поиск
Список
Период
Сортировка
От Hans-Jürgen Schönig
Тема Passing parameters to triggers
Дата
Msg-id 3C90B624.4AF5875F@cybertec.at
обсуждение исходный текст
Ответы Re: Passing parameters to triggers  (Jan Wieck <janwieck@yahoo.com>)
Re: Passing parameters to triggers  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I have a severe problem when working with PL/pgSQL triggers. Somehow the
problem seems to be strange. Here is the code:

CREATE OR REPLACE FUNCTION checkint () RETURNS opaque AS
'
        BEGIN
                IF      TG_OP = ''DELETE'' THEN
                        RAISE NOTICE ''% wert'', TG_ARGV[0];
                        DELETE FROM TG_ARGV[0];
                END IF;
                RETURN OLD;
        END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER trig_a_b AFTER DELETE OR UPDATE ON a
        FOR EACH ROW EXECUTE PROCEDURE checkint('b');

DELETE FROM a;

When running the code I get a strange problem. The RAISE NOTICE command
works but somehow the DELETE statements displays an error.

NOTICE:  b wert
NOTICE:  Error occurred while executing PL/pgSQL function checkint
NOTICE:  line 4 at SQL statement
ERROR:  parser: parse error at or near "$1"

Does anybody know what I can do?

    Hans


В списке pgsql-general по дате отправления:

Предыдущее
От: "Jakub Gañko"
Дата:
Сообщение: how to install Postgresql on Windows2000 ? Please send me detaily discription.
Следующее
От: Masaru Sugawara
Дата:
Сообщение: Re: SQL Server performing much better?!?!