Skip site navigation (1) Skip section navigation (2)

view triggers/procedures

From: "SVGK, Raju (Raju)" <svgk(at)lucent(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: view triggers/procedures
Date: 2004-08-23 10:06:03
Message-ID: 6733C768256DEC42A72BAFEFA9CF06D20AC2F154@ii0015exch002u.iprc.lucent.com (view raw or flat)
Thread:
Lists: pgsql-general
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"('<unnamed>', '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"('<unnamed>', '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"('<unnamed>', '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"('<unnamed>', '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"('<unnamed>', '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"('<unnamed>', 'defects', 'reviews', 'UNSPECIFIED',
'review_id', 'review_id')

Responses

pgsql-general by date

Next:From: Daniel MartiniDate: 2004-08-23 10:18:40
Subject: Re: pg_dump in stand alone backend
Previous:From: Graeme HinchliffeDate: 2004-08-23 08:53:43
Subject: Catching server shutdown in C

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group