Re: Indicate disabled triggers in \d - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Indicate disabled triggers in \d
Date
Msg-id 454F42D0.8070009@dunslane.net
Whole thread Raw
In response to Re: Indicate disabled triggers in \d  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Indicate disabled triggers in \d
List pgsql-hackers
Tom Lane wrote:
> "Brendan Jurd" <direvus@gmail.com> writes:
>   
>> My first impulse was to just append a " (disabled)" after each
>> disabled trigger, but perhaps that is not visually obvious enough,
>> especially if the table has many triggers on it.
>>     
>
> Agreed, but maybe put it up at the front?
>
> Triggers:
>     y AFTER DELETE ON x FOR EACH ROW EXECUTE PROCEDURE do_something()
>     z (disabled) BEFORE INSERT ON x FOR EACH ROW EXECUTE PROCEDURE input_stuff()
>
>     
>   

+1. This bit me recently. Or maybe, in the interests of preserving 
screen space, a [*] for enabled and [x] for disabled, or something similar.

cheers

andrew



pgsql-hackers by date:

Previous
From: "Dr. Ernst Molitor"
Date:
Subject: Re: WITH SYSID dropped
Next
From: Tom Lane
Date:
Subject: Re: Is python 2.5 supported?