On May 19, 2010, at 11:41 AM, Little, Douglas wrote: > Hi, > > 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 > > Any suggestions? Take it up with your vendor. That's what you're paying them for, and they're the only ones who are likely to understand how their product works. If you were using postgresql I'd suggest looking at the log_statement and log_line_prefix options, to see if tracking DDL that way were adequate for what you need. Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
