Postgres Triggers issue

Поиск
Список
Период
Сортировка
От u235sentinel
Тема Postgres Triggers issue
Дата
Msg-id 4B73843E.10900@gmail.com
обсуждение исходный текст
Ответы Re: Postgres Triggers issue  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: Postgres Triggers issue  ("Igor Neyman" <ineyman@perceptron.com>)
Список pgsql-general
I have a strange problem we noticed the other day with triggers.  We're
running 8.3.3 on Solaris 10 (intel) and have a feed that comes in
regularly to populate a table we're working on.  The feed works just
fine inserting rows however the following trigger stops the feed until
we remove the trigger.  Any thoughts on what I'm doing wrong here?

Thanks!

---

CREATE OR REPLACE FUNCTION r.m_t()
RETURNS trigger AS
$BODY$
BEGIN
 INSERT INTO temp_m_t VALUES (NEW.*,1+1);
RETURN NULL;
END;
$BODY$
LANGUAGE 'plpgsql';


CREATE TRIGGER tafter
AFTER INSERT OR UPDATE
ON r.m_a
FOR EACH ROW
EXECUTE PROCEDURE r.m_t();


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

Предыдущее
От: "Wang, Mary Y"
Дата:
Сообщение: Re: How do I drop a Complicated Constraint Trigger After Delete Execute Procedure?
Следующее
От: "Wang, Mary Y"
Дата:
Сообщение: Re: How do I drop a Complicated Constraint Trigger After Delete Execute Procedure?