Re: Vacuum with Views

Michael Fuhr wrote:

>On Wed, Aug 03, 2005 at 12:26:32PM -0400, John J. Urbaniak wrote:
>
>
>>Does the vacuum procedure mess up my views? It seems as if it does.
>>
>>
>
>Could elaborate on how vacuum "seems to mess up" your views? What
>are you doing, what are you expecting to happen, and what actually
>does happen?
>
>
>
I am not sure. Somehow my views were destroyed. I have a Work Order
table, and a Resources table (many Resources to one Work Order). These
tables are joined by the Work Order number into a View, which I call
ActiveWOs. I have a print module that prints from this view.

The print module worked, then all of a sudden stopped working. It
caused a crash in my system which required me to reconnect to PGS, and
maybe also to shut down the server and restart it.

The only thing I remember doing to this was use a vacuum procedure in a
backup utility I am writing.

When I rebuilt the views (with a program), everything is back to normal
and the Work Orders print ok.

I am using Object Rexx to interface eCS with PGS.

I am trying to trace down the culprit.

Can I be sure that if I delete some records from some tables, then
vacuum the database, that views involving those tables are preserved?

John