Josh Berkus <josh(at)agliodbs(dot)com> writes:
> 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.
That makes more sense to me --- it would easily extend to all cases
and would not impose any overhead (in the form of useless columns)
for catalogs that you didn't want to track in a particular case.
The main problem that would have to be considered is how to flush
no-longer-useful entries (which of course entails deciding which
those are).
regards, tom lane