Postgres Pro
Downloads
Home   >   mailing lists

Re: Add create and update timestamp to all objects - Mailing list pgsql-hackers

From Nikolay Samokhvalov
Subject Re: Add create and update timestamp to all objects
Date
Msg-id CANNMO++o2=nXSB5jmKCknAtMeR_EXN2FHPtPTN-Bbc3wKVZWVQ@mail.gmail.com
Whole thread Raw
In response to Add create and update timestamp to all objects  ("Efrain J. Berdecia" <ejberdecia@yahoo.com>)
List pgsql-hackers
Tree view
On Sun, Sep 26, 2021 at 1:11 PM Efrain J. Berdecia <ejberdecia@yahoo.com> wrote:
Are there any plans to add a create and last updated time stamp field to any and all objects in postgres?

Possibly even adding a updated_by documenting which role created and last updated the object.

All done natively and without the need for extra extensions.

Thanks in advance.

Why would you need that? Each timestamp[tz] value is 8 bytes.

And setting up values via defaults and triggers is straightforward, isn't it?

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: extended stats on partitioned tables
Next
From: Jean-Christophe Arnu
Date:
Subject: Re: Empty string in lexeme for tsvector