From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: proposal: add columns created and altered to pg_proc and pg_class |
Date: | 2009-04-14 04:07:02 |
Message-ID: | 162867790904132107h60defa9dq183c53798e647a08@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2009/4/14 Josh Berkus <josh(at)agliodbs(dot)com>:
>
>>> - what if I need to know about operators, operator classes, schemas, etc
>>> etc
>>
>> Fine, let's log this info for those too (or else decide they're too
>> obscure and don't - pg_class and pg_proc are certainly the most
>> interesting cases).
>
> I would suggest putting this info in a separate table, pg_change. It would
> have oid, catalog, user_changed, changed_on. That way we could simply keep
> the data for all objects which have an OID.
>
> This would also supposedly allow us to track drops if we wanted.
>
> We'd have to check on overhead of this, though, and maybe make it a GUC to
> track it.
>
> This would also be tremendously useful to suppliment replication systems.
>
I though about it too. But I am not sure, if this isn't too
complicated solution for simple task. If I thing little bit more -
main important is timestamp of last change.
regards
Pavel Stehule
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> www.pgexperts.com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2009-04-14 04:07:27 | Re: Unicode support |
Previous Message | Robert Haas | 2009-04-14 03:58:59 | Re: proposal: add columns created and altered to pg_proc and pg_class |