On 12/24/19 1:14 PM, Rob Sargent wrote:
If there's not enough time and motivation for the developers to implement CREATED_ON and LAST_ALTERED in pg_class, then you should have said that in the first place. We're adults; we understand that OSS projects have limited resources, and won't go off and pout in the corner.
But that's not what y'all said. "It's too complicated, mission creep, blah blah blah" just extended way too long.
Is there a list of purported uses cases for these two attributes (other than auditing)? Especially anything to do with managing the data as they currently exist?
I've used last_altered for comparing tables on Staging and
Prod database.
If, for example, the last_altered on a prod table is
earlier
than last_altered on the staging table, then that's a
strong
hint that the staging and prod schema are out of sync,
and more detailed examination is required.
Another example is that -- since username is also recorded in
other RDBMSs --it's useful when the customer is screaming at
your boss asking who made that unauthorized modification to
production that's breaking their application. You then show
them that the table hasn't been altered in X months, and point
the finger back at their incompetent developers.
All in all, it's not something that you use every day, but
when it
is useful, it's
very useful.
