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

Re: system_information.triggers & truncate triggers

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: Daymel Bonne Solís <dbonne(at)uci(dot)cu>
Cc: postgres-devel <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: system_information.triggers & truncate triggers
Date: 2012-09-26 05:55:55
Message-ID: CAJKUy5g_c+jbUWx==2jzZitTs01eixy5u04VZ_7c4_bH9cUw-g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Sep 26, 2012 at 12:17 AM, Daymel Bonne Solís <dbonne(at)uci(dot)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

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación


In response to

Responses

pgsql-hackers by date

Next:From: Виктор ЕгоровDate: 2012-09-26 05:57:06
Subject: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries.
Previous:From: Daymel Bonne SolísDate: 2012-09-26 05:17:07
Subject: system_information.triggers & truncate triggers

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