Thread

  1. VACUUM in a trigger

    Brett W. McCoy <bmccoy@lan2wan.com> — 1999-04-19T20:48:59Z

    Can a VACUUM statement be used inside of a trigger?  I want to set up a
    trigger that will run a vaccum after certain tables have been updated a
    set number of times. 
    
    Brett W. McCoy           
                                             http://www.lan2wan.com/~bmccoy
    -----------------------------------------------------------------------
    Westheimer's Discovery:
    	A couple of months in the laboratory can frequently save a
    couple of hours in the library.
    
    
    
  2. Re: [SQL] VACUUM in a trigger

    Brian <signal@shreve.net> — 1999-04-19T21:35:02Z

    On Mon, 19 Apr 1999, Brett W. McCoy wrote:
    
    > Can a VACUUM statement be used inside of a trigger?  I want to set up a
    > trigger that will run a vaccum after certain tables have been updated a
    > set number of times. 
    
    Can you have a trigger execute a unix shell command? Can someone give an
    example?
    
    
    > 
    > Brett W. McCoy           
    >                                          http://www.lan2wan.com/~bmccoy
    > -----------------------------------------------------------------------
    > Westheimer's Discovery:
    > 	A couple of months in the laboratory can frequently save a
    > couple of hours in the library.
    > 
    > 
    
    -----------------------------------------------------
    Brian Feeny (BF304)     signal@shreve.net   
    318-222-2638 x 109	http://www.shreve.net/~signal      
    Network Administrator   ShreveNet Inc. (ASN 11881)