X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87D035E3639 for ; Fri, 20 Aug 2004 12:56:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67389-09 for ; Fri, 20 Aug 2004 15:56:07 +0000 (GMT) Received: from ihemail2.lucent.com (ihemail2.lucent.com [192.11.222.163]) by svr1.postgresql.org (Postfix) with ESMTP id F0BBC5E3632 for ; Fri, 20 Aug 2004 12:55:58 -0300 (ADT) Received: from ii0015exch002u.wins.lucent.com (h135-254-246-205.lucent.com [135.254.246.205]) by ihemail2.lucent.com (8.12.11/8.12.11) with ESMTP id i7KFu27e016845 for ; Fri, 20 Aug 2004 10:56:03 -0500 (CDT) Received: by ii0015exch002u.iprc.lucent.com with Internet Mail Service (5.5.2657.72) id ; Fri, 20 Aug 2004 21:26:01 +0530 Message-ID: <6733C768256DEC42A72BAFEFA9CF06D20AC2F14B@ii0015exch002u.iprc.lucent.com> From: "SVGK, Raju (Raju)" To: "'pgsql-sql@postgresql.org'" Subject: view triggers/procedures Date: Fri, 20 Aug 2004 21:25:54 +0530 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200408/269 X-Sequence-Number: 18766 Hi, I have a table where in lot of triggers were included in that as shown below. How to view/access triggers and procedures from postgresql. I am using postgresql 7.4.1 on solaris. regds -raju Process=# \d reviews Table "public.reviews" Column | Type | Modifiers ------------------+-----------------------+--------------------------------- -------------------------- review_id | integer | not null default nextval('"reviews_review_id_seq"'::text) project | character varying(32) | not null phase | character varying(32) | not null default 'Unknown'::character varying artifact_type | character varying(32) | not null description | text | author | character varying(32) | moderator | character varying(32) | meeting_end_date | date | meeting_date | date | formal | boolean | default true status | character varying(16) | disposition | character varying(16) | default 'To be decided'::character varying comments | text | num_attendees | smallint | review_size | smallint | kickoff_time | smallint | meeting_time | smallint | review_name | character varying(64) | rework_effort | integer | default 0 Indexes: "reviews_pkey" primary key, btree (review_id) Triggers: "RI_ConstraintTrigger_414655" AFTER DELETE ON reviews FROM documents NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del"('', 'documents', 'reviews', 'UNSPECIFIED', 'review_id', 'review_id') "RI_ConstraintTrigger_414656" AFTER UPDATE ON reviews FROM documents NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd"('', 'documents', 'reviews', 'UNSPECIFIED', 'review_id', 'review_id') "RI_ConstraintTrigger_414658" AFTER DELETE ON reviews FROM inspectors NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del"('', 'inspectors', 'reviews', 'UNSPECIFIED', 'review_id', 'review_id') "RI_ConstraintTrigger_414659" AFTER UPDATE ON reviews FROM inspectors NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd"('', 'inspectors', 'reviews', 'UNSPECIFIED', 'review_id', 'review_id') "RI_ConstraintTrigger_414661" AFTER DELETE ON reviews FROM defects NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del"('', 'defects', 'reviews', 'UNSPECIFIED', 'review_id', 'review_id') "RI_ConstraintTrigger_414662" AFTER UPDATE ON reviews FROM defects NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd"('', 'defects', 'reviews', 'UNSPECIFIED', 'review_id', 'review_id')