| From: | Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> |
|---|---|
| To: | "Efrain J(dot) Berdecia" <ejberdecia(at)yahoo(dot)com> |
| Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Add create and update timestamp to all objects |
| Date: | 2021-09-26 20:39:48 |
| Message-ID: | CANNMO++o2=nXSB5jmKCknAtMeR_EXN2FHPtPTN-Bbc3wKVZWVQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, Sep 26, 2021 at 1:11 PM Efrain J. Berdecia <ejberdecia(at)yahoo(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christophe Arnu | 2021-09-26 20:41:13 | Re: Empty string in lexeme for tsvector |
| Previous Message | Justin Pryzby | 2021-09-26 20:25:50 | Re: extended stats on partitioned tables |