Re: [SQL] VACUUM in a trigger

Brian <signal@shreve.net>

From: Brian <signal@shreve.net>
To: "Brett W. McCoy" <bmccoy@lan2wan.com>
Cc: pgsql-sql@postgreSQL.org
Date: 1999-04-19T21:35:02Z
Lists: pgsql-sql
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)