X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB01A5396F for ; Mon, 25 Apr 2005 23:09:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22376-07 for ; Tue, 26 Apr 2005 02:09:31 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5670553920 for ; Mon, 25 Apr 2005 23:09:31 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j3Q29UlJ023765 for ; Tue, 26 Apr 2005 02:09:30 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j3Q24IAQ022039 for pgsql-admin@postgresql.org; Tue, 26 Apr 2005 02:04:18 GMT (envelope-from news) From: Ezequiel Tolnay X-Newsgroups: pgsql.admin Subject: pg_version_history Date: Tue, 26 Apr 2005 12:04:30 +1000 Organization: Hub.Org Networking Services Lines: 11 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050319 X-Accept-Language: en-au, en-gb, en-us, en, es-ar, es-es To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/408 X-Sequence-Number: 17421 I found a table pg_version_history in the public schema (which we don't use). Does anyone know where this table comes from and what is it for? Also I'd like to implement a code versioning for the functions. Is there a package or a software to do this kind of things, so we can recover from it a function in case it is deleted or overwritten with an old version? Thanks Ezequiel Tolnay etolnay@gbtech.com.au