* Stephen Frost <
sfrost@snowman.net> wrote:
>
> Yes, and have the actual 'description' field (as it's variable) at the
> end of the catalog.
>
> Regarding the semantics of it- I was thinking about how directories and
> unix files work. Basically, adding or removing a sub-object would
> update the alter time on the object itself, changing an already existing
> object or sub-object would update only the object/sub-object's alter
> time. Creating an object or sub/object would set its create time and
> alter time to the same value. I would distinguish 'create' from
> 'ctime', however, and have our 'create' time be only the actual
> *creation* time of the object. ALTER table OWNER TO user; would update
> "table"s alter time.
>
Understood... a "COMMENT" is a database object, then if we add a creation time column to pg_description/shdescription tables how we track his creation time?
>
> Open to other thoughts on this and perhaps we should create a wiki page
> to start documentating the semantics. Once we get agreement there, it's
> just a bit of code. :)
>
+1
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI:
http://fabriziomello.blogspot.com>> Perfil Linkedin:
http://br.linkedin.com/in/fabriziomello >> Twitter:
http://twitter.com/fabriziomello
