I have a fairly large data warehouse in Greenplum, and am having trouble tracking object changes.
I need to
1. Know when an object was changed, by who.
2. Have some logging about when an object was dropped - especially drop cascade.
Currently I'm having a problem with a set of disappearing views. We're still in pre-prod environment, but
1. PG to timestamp the catalog tables
2. Permit triggers on catalog objects.
Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
[cid:image001.jpg@01CAF759.01607890] orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>