Which trigger execute which function?

Поиск
Список
Период
Сортировка
От Raymond Chui
Тема Which trigger execute which function?
Дата
Msg-id 3C7CFBEF.58125413@noaa.gov
обсуждение исходный текст
Ответы Re: Which trigger execute which function?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [ADMIN] Which trigger execute which function?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Previous DBA create a lot of triggers and functions without
documentation like:

CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name
FOR EACH ROW EXECUTE PROCEDURE function_name();

Now he is gone. I couldn't find his PL/PGSQL source codes!

I can do

SELECT * FROM pg_proc;
SELECT * FROM pg_trigger;

to list all the name of triggers and functions. But I don't know which
trigger
execute which function. How do I find out that?

Our USENET new server (NNTP) doesn't have comp.databases.postgresql.*
news groups. Therefore, please cc: a copy to me if you reply.
Thank Q very much in advance!




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

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: postgre performance question
Следующее
От: "Eugene Chiu"
Дата:
Сообщение: Client only deployment