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!
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 |
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 |