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 923345296F for ; Wed, 20 Apr 2005 00:37:56 -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 98944-06 for ; Wed, 20 Apr 2005 03:37:53 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 354D152966 for ; Wed, 20 Apr 2005 00:37:53 -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 j3K3bq9V001619 for ; Wed, 20 Apr 2005 03:37:53 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j3K3bCv5001521 for pgsql-admin@postgresql.org; Wed, 20 Apr 2005 03:37:12 GMT (envelope-from news) From: Ezequiel Tolnay X-Newsgroups: pgsql.admin Subject: Re: SQL code versioning (views, functions, etc) Date: Wed, 20 Apr 2005 13:37:44 +1000 Organization: Hub.Org Networking Services Lines: 9 Message-ID: References: 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 In-Reply-To: To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/337 X-Sequence-Number: 17350 I just discovered that in the public schema (which I don't use) there is a table pg_version_history. Does anyone know about this table? It has versions of two test functions I seem to have created a couple of months ago when I first installed postgresql, but I have no idea how this table was created or what is its purpose, since although it seems to be used to keep track of changes of function code (which is what I'm looking for) it only has these two test functions, and I've created many using different software.