Re: [SQL] VACUUM in a trigger - Mailing list pgsql-sql

From Brian
Subject Re: [SQL] VACUUM in a trigger
Date
Msg-id Pine.LNX.4.10.9904191634380.4259-100000@mercury.shreve.net
Whole thread Raw
In response to VACUUM in a trigger  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List 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)           



pgsql-sql by date:

Previous
From: "Giovanni Battista, Stefanoni"
Date:
Subject: 6.4.2 and LEFT/RIGHT OUTER JOIN
Next
From: JT Kirkpatrick
Date:
Subject: problem when vacuuming. . .