Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Дата
Msg-id CAKFQuwan+jQKCHqQvhcRjCmiqHD8rSyjtmr3RNWMk1O=ZcGV-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
On Thu, Apr 21, 2016 at 8:18 AM, Melvin Davidson <melvin6925@gmail.com> wrote:
On Thu, Apr 21, 2016 at 11:08 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 04/21/2016 07:53 AM, Melvin Davidson wrote:


"Whether that is worthy or not is the point of your request and really
depends on more input."
Correct. And that is what I am looking for. Stating obscure corner cases
does not rule out the need for an enhancement. If it did, there would be
no point in any enhancement.
As of yet, other than this will not work for certain cases, I have not
heard any argument where this would cause harm to the PostgreSQL
database (performance or security concern)
or that this will take any great effort to implement, as I have already
disproved that in a previous update.

Making OIDs a default column on user tables was probably not a great effort either. Easy and all user tables got a built in PK, until folks started pushing more data into their database and the OID counter wrapped which had consequences for both user and system tables. Just saying I would want to hear more from the folks that deal with the internals.


And your point is? Adding an nullable column with a default of now() to a system catalog has no impact whatsoever on OID's.
Please state a relevant  case how this negatively impacts anything.

​Y​
our grasp of analogy
​ could use some work...

That was a long winded way of saying that there is this thing called "unintended consequences".​
 


Fear of both "unexpected drawbacks" and "perverse ​results" exist here.

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: setting time zone in a function
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Columnar store as default for PostgreSQL 10?