We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


tracking object changes in Vertica — Vertica Forum

tracking object changes in Vertica

Is there a way to find out who made the latest modification to an object such as a table or view in release 7.1?

Thanks

Comments

  • There are two types of objects whose last modified time is recorded.

     

    In the system table PROJECTION_DELETE_CONCERNS: 

    Lists projections whose design may cause performance issues when deleting data. This table is generated by calling the EVALUATE_DELETE_PERFORMANCE function.

     

    In the system table COMMENTS, which contains information about comments associated with objects in the database.

     

    Hope that helps,

     

    Sarah

  • Although the retention may be limited, you may want to try looking in query_requests:

     

    select start_timestamp, user_name, request from query_requests where request_type = 'DDL';

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file