Re: Proposal: Store "timestamptz" of database creation on "pg_database"

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Дата
Msg-id 20130103143012.GB5506@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Proposal: Store "timestamptz" of database creation on "pg_database"  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Proposal: Store "timestamptz" of database creation on "pg_database"  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Список pgsql-hackers
Peter Eisentraut escribió:

> If we're going to store object creation time, I think we should do it
> for all objects, stored in a separate catalog, like pg_depend or
> pg_description, keyed off classid, objectid.  And have a simple C
> function to call to update the information stored there.

+1

We require two catalogs though, one shared, one database-local.

Would we track ctime of subsidiary objects such as constraints etc?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: dynamic SQL - possible performance regression in 9.2