Re: psql should show disabled internal triggers - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: psql should show disabled internal triggers
Date
Msg-id 20140224174512.GD16943@momjian.us
Whole thread Raw
In response to Re: psql should show disabled internal triggers  (Bruce Momjian <bruce@momjian.us>)
Responses Re: psql should show disabled internal triggers  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Wed, Feb 12, 2014 at 09:04:45PM -0500, Bruce Momjian wrote:
> As others, I am concerned about people being confused when funny-looking
> trigger names suddenly appearing when you disable all table triggers.
> 
> What I ended up doing is to create a user and internal section when
> displaying disabled triggers:
> 
>     Disabled user triggers:
>         check_update BEFORE UPDATE ON orders FOR EACH ROW EXECUTE PROCEDURE trigf()
>     Disabled internal triggers:
>         "RI_ConstraintTrigger_c_16409" AFTER INSERT ON orders FROM customer NOT DEF ...
>         "RI_ConstraintTrigger_c_16410" AFTER UPDATE ON orders FROM customer NOT DEF ...
>     
> I kept the "Triggers" section unchanged, showing only user triggers.  I
> also updated the code to handle 8.3+ servers.
> 
> Patch attached.

Patch applied.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Minor performance improvement in transition to external sort
Next
From: Robert Haas
Date:
Subject: Re: Changeset Extraction v7.6.1