How to find not up-to-date projection

scherepanov

Hi,

Vertica Management Console (v 24.3.0-1) show presence of not up-to-date projection in database. I cannot find it in MC - there is a defect in MC, it cannot show tables for all schema, only for single schema at time, and I have way too many schemas and too little patience to go over all of them. MC link to not up-to-date projections just leads to first schema by alphabetical order.

Checking systems views like projections etc does not show how I can find projections.

Can you share a query used by MC to find not up-to-date projections.

Thank you
Sergey

scherepanov

@SruthiA can you look it out

SruthiA

Could you please open a support case?

scherepanov

I missed column is_up_to_date in projection systems table.