Postgres Pro
Downloads
Home   >   mailing lists

Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Date
Msg-id CANu8FizTooZPMs=G5N0Pd5xB1J=i9nLM_CwC6Ni4zkT3EV6ztA@mail.gmail.com
Whole thread Raw
In response to Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
List pgsql-general
Tree view
"and what about user objects added to a database which is
then used as a template for creating another DB ?"

This existence of objects that are part of the default schema is NOT a problem. Developers and users should never have access to a template. The point is to be able to track down rogue objects created  by developers and users and at the same time add the same functionality as already is in Oracle and SQL Server. What would be your solution?


Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Next
From: Tom Lane
Date:
Subject: Re: setting time zone in a function