Which trigger execute which function?

From: "Raymond Chui" <Raymond(dot)Chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Which trigger execute which function?
Date: 2002-02-27 15:31:59
Message-ID: 3C7CFBEF.58125413@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Eugene Chiu 2002-02-27 16:04:49 Client only deployment
Previous Message Henshall, Stuart - WCP 2002-02-27 15:29:28 Re: Problem in installing PostgreSQL7.1.2 on Windows2000

Browse pgsql-general by date

  From Date Subject
Next Message David Blood 2002-02-27 15:32:30 sort mem size
Previous Message Peter Peltonen 2002-02-27 15:12:03 About vacuuming