Re: [SQL] VACUUM in a trigger

Поиск
Список
Период
Сортировка
От Brian
Тема Re: [SQL] VACUUM in a trigger
Дата
Msg-id Pine.LNX.4.10.9904191634380.4259-100000@mercury.shreve.net
обсуждение исходный текст
Ответ на VACUUM in a trigger  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Список 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 по дате отправления:

Предыдущее
От: "Giovanni Battista, Stefanoni"
Дата:
Сообщение: 6.4.2 and LEFT/RIGHT OUTER JOIN
Следующее
От: JT Kirkpatrick
Дата:
Сообщение: problem when vacuuming. . .