Vacuum with Views

From: "John J(dot) Urbaniak" <jjurban(at)attglobal(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Vacuum with Views
Date: 2005-08-03 16:26:32
Message-ID: 42F0F038.5050906@attglobal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-08-03 16:28:32 sql question
Previous Message jason.ctr.alburger 2005-08-03 14:19:25 Fw: SQL error code -601 <ECPG_WARNING_QUERY_IGNORED>