Postgres Pro
Downloads
Home   >   mailing lists

Thread: VACUUM in a trigger

VACUUM in a trigger

From
"Brett W. McCoy"
Date:
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.

Re: [SQL] VACUUM in a trigger

From
Brian
Date:
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)