Re: system_information.triggers & truncate triggers

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