On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova <ja...@2ndquadrant.com> wrote: > On Wed, Sep 26, 2012 at 12:17 AM, Daymel Bonne Solís <dbo...@uci.cu> wrote: >> Hello hackers: >> >> I need a list of all triggers created in my database, but the view >> system_information.triggers does not show truncate triggers, but it does for >> insert, update and delete triggers. >> >> The same problem is found in versions 9.1 and 9.2. >> > > The definition of information_schema.triggers contains this: > """ > FROM pg_namespace n, pg_class c, pg_trigger t, > -- hard-wired refs to TRIGGER_TYPE_INSERT, TRIGGER_TYPE_DELETE, > -- TRIGGER_TYPE_UPDATE; we intentionally omit TRIGGER_TYPE_TRUNCATE > (VALUES (4, 'INSERT'), > (8, 'DELETE'), > (16, 'UPDATE')) AS em (num, text) > """ > > so it seems that we are not showing TRUNCATE triggers intentionally, > but that comment fails to explain why
Wouldn't it be because TRUNCATE is a PostgreSQL language extension? -- fdr -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
