Postgres Triggers issue

Поиск
Список
Период
Сортировка
От u235sentinel
Тема Postgres Triggers issue
Дата
Msg-id 4B730B6F.8040105@gmail.com
обсуждение исходный текст
Ответ на Re: Some belated patch review for "Buffers" explain analyze patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Postgres Triggers issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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-hackers по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: [CFReview] Red-Black Tree
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Writeable CTEs and empty relations