view triggers/procedures

Поиск
Список
Период
Сортировка
От SVGK, Raju (Raju)
Тема view triggers/procedures
Дата
Msg-id 6733C768256DEC42A72BAFEFA9CF06D20AC2F154@ii0015exch002u.iprc.lucent.com
обсуждение исходный текст
Ответы Re: view triggers/procedures  (Csaba Nagy <nagy@ecircle-ag.com>)
Список 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')

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

Предыдущее
От: Daniel Martini
Дата:
Сообщение: Re: pg_dump in stand alone backend
Следующее
От: Csaba Nagy
Дата:
Сообщение: Re: view triggers/procedures