Postgres Pro
Downloads
Home   >   mailing lists

object tracking - Mailing list pgsql-general

From Little, Douglas
Subject object tracking
Date
Msg-id 8585BA53443004458E0BAA6134C5A7FB0638E423@EGEXCMB01.oww.root.lcl
Whole thread Raw
Responses Re: object tracking  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: object tracking  (Steve Atkins <steve@blighty.com>)
Re: object tracking  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view

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?

 

I’d like  

1.        PG to timestamp the catalog tables

2.       Permit triggers on catalog objects.

 

 

Doug Little

 

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

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Attachment

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: CIDR data type query help
Next
From: Hernan Danielan
Date:
Subject: Re: Connection lost