Thread: object tracking

On Wed, 2010-05-19 at 13:41 -0500, Little, Douglas wrote:
> Hi,
>
>
>
> I have a fairly large data warehouse in Greenplum, and am having
> trouble tracking object changes.
>

Depends on Greenplum I would assume. I don't know how compatible they
are with .Org anymore. You might look at table_log

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering

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

On Wed, 2010-05-19 at 13:41 -0500, Little, Douglas wrote:
> Hi,
>
>
>
> I have a fairly large data warehouse in Greenplum, and am having
> trouble tracking object changes.
>

Depends on Greenplum I would assume. I don't know how compatible they
are with .Org anymore. You might look at table_log

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering