View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 05:32 AM
Tom Lane
 
Posts: n/a
Default Re: Indicate disabled triggers in \d

"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()

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote