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: (view raw, whole thread or download thread mbox)
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
Professional PostgreSQL: Soporte 24x7 y capacitación

In response to


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-2017 The PostgreSQL Global Development Group