Postgres Pro
Downloads
Home   >   mailing lists

Vacuum with Views - Mailing list pgsql-novice

From John J. Urbaniak
Subject Vacuum with Views
Date
Msg-id 42F0F038.5050906@attglobal.net
Whole thread Raw
Responses Re: Vacuum with Views  (Michael Fuhr <mike@fuhr.org>)
Leading Zeros  (<operationsengineer1@yahoo.com>)
List pgsql-novice
Tree view 
Hello,

I have a system converted from DB2 to PostGreSQL, running on eCS.

The system has about 36 tables and maybe 10 views.

I am writing a PGS backup procedure which includes a vacuumdb call.

Question:

Does the vacuum procedure mess up my views?  It seems as if it does.

Thank you.

John

pgsql-novice by date:

Previous
From: jason.ctr.alburger@faa.gov
Date:
Subject: Fw: SQL error code -601
Next
From:
Date:
Subject: sql question