Re: Add create and update timestamp to all objects

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема Re: Add create and update timestamp to all objects
Дата
Msg-id CANNMO++o2=nXSB5jmKCknAtMeR_EXN2FHPtPTN-Bbc3wKVZWVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Add create and update timestamp to all objects  ("Efrain J. Berdecia" <ejberdecia@yahoo.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: extended stats on partitioned tables
Следующее
От: Jean-Christophe Arnu
Дата:
Сообщение: Re: Empty string in lexeme for tsvector