Re: [SQL] Object create date

Hi About three years ago we started doing nightly schema dumps of all our databases and then updating these into CVS. That has proven to be pretty useful when there is need to determine when some change was done in database. regards, Asko On Tue, Dec 30, 2008 at 7:33 PM, Erik Jones wrote: > >

Re: [SQL] Object create date

On Dec 29, 2008, at 12:30 PM, George Pavlov wrote: 1. not exactly what you were looking for, but i answer this partially by putting a commented-out CVS expansion tag (e.g. $Id:) in the body of the function so that it gets into the catalog and can be searched: CREATE OR REPLACE FUNCTION

Re: [SQL] Object create date

> -Mensaje original- > De: Alvaro Herrera [mailto:alvhe...@commandprompt.com] > Enviado el: Lunes, 29 de Diciembre de 2008 19:39 > Para: Fernando Hevia > CC: 'George Pavlov'; pgsql-sql@postgresql.org > Asunto: Re: [SQL] Object create date > > Fernando

Re: [SQL] Object create date

Fernando Hevia escribió: > Thanks Pavlov for your response. > > CREATE OR REPLACE FUNCTION foo () > > RETURNS void AS > > $BODY$ > > -- $Id: foo.sql,v 1.6 2008/12/23 00:06:52 gpavlov Exp $ > > BEGIN > > ... > > > > I am already doing this. Sadly I've found it to be very fragile in >

Re: [SQL] Object create date

Thanks Pavlov for your response. > -Mensaje original- > De: George Pavlov [mailto:gpav...@mynewplace.com] > wrote: > > Hi list, > > > > I'm having a hard time trying to find out if the latest > patches have > > been applied to my application (uses lots of pgplsql functions). > > Does P

Re: [SQL] Object create date

> -Mensaje original- > De: pgsql-sql-ow...@postgresql.org > [mailto:pgsql-sql-ow...@postgresql.org] En nombre de Scott Marlowe > > On Mon, Dec 29, 2008 at 11:23 AM, Fernando Hevia > wrote: > > Hi list, > > > > I'm having a hard time trying to find out if the latest > patches have > >

Re: [SQL] Object create date

Fernando Hevia > Sent: Monday, December 29, 2008 10:23 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] Object create date > > Hi list, > > I'm having a hard time trying to find out if the latest patches have > been applied to my application (uses lots of pgplsql functions

Re: [SQL] Object create date

Fernando Hevia escribió: Hi, > I'm having a hard time trying to find out if the latest patches have > been applied to my application (uses lots of pgplsql functions). > Does Postgres store creation date and/or modification date for tables, > functions and other objects? No. -- Alvaro Herrera

Re: [SQL] Object create date

On Mon, Dec 29, 2008 at 11:23 AM, Fernando Hevia wrote: > Hi list, > > I'm having a hard time trying to find out if the latest patches have been > applied to my application (uses lots of pgplsql functions). > Does Postgres store creation date and/or modification date for tables, > functions and ot

[SQL] Object create date

Hi list, I'm having a hard time trying to find out if the latest patches have been applied to my application (uses lots of pgplsql functions). Does Postgres store creation date and/or modification date for tables, functions and other objects? It would help me a lot if I could query each object

Re: [SQL] Object Create Date

Sameer Deshpande wrote: Hello, Which data dictionary I have to query to determine the object creation date.. F.ex I would like to find out on which date table or Index has been created.. You can't. Regards Gaeatano Mendola ---(end of broadcast)---