Problems with trigger and function.

Поиск
Список
Период
Сортировка
От Ville Leinonen
Тема Problems with trigger and function.
Дата
Msg-id 12182.194.240.150.6.1118661317.squirrel@194.240.150.6
обсуждение исходный текст
Ответы Re: Problems with trigger and function.  (Michael Fuhr <mike@fuhr.org>)
Re: Problems with trigger and function.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi all,

Id like to to function with plperlu which write's db-events to log-file.
My trigger looks like this:

CREATE TRIGGER trapd
     BEFORE INSERT OR UPDATE ON events FOR EACH ROW
     EXECUTE PROCEDURE write_trapd();

But now i have a problem how to write that event information for specific
file. I dont want to write whole event, only part offit.

Does anyone have suggestion how to do this?

My goal is to read that log file (eg. tail) and when there comes new event
some other programs executes some other programs.

Best regards,

Name: Ville Leinonen
E-mail: ville.leinonen@megata.vu


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

Предыдущее
От: Volkan YAZICI
Дата:
Сообщение: Steps taken through while transmitting binary data
Следующее
От: János
Дата:
Сообщение: Re: need suggestion for server sizing