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 8EF3752A88 for ; Wed, 20 Apr 2005 00:37:57 -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 98901-04 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 0D64D52961 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 j3K3bq9T001619 for ; Wed, 20 Apr 2005 03:37:52 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j3K3M4CA097685 for pgsql-admin@postgresql.org; Wed, 20 Apr 2005 03:22:04 GMT (envelope-from news) From: Ezequiel Tolnay X-Newsgroups: pgsql.admin Subject: SQL code versioning (views, functions, etc) Date: Wed, 20 Apr 2005 13:22:36 +1000 Organization: Hub.Org Networking Services Lines: 15 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/326 X-Sequence-Number: 17339 Hi all you pg gurus and admins, I'm trying to implement versioning of the code of objects that can be "created or replaced" (functions, views, etc). I tried to implement a trigger on pg_proc, but that is not possible. Adding a rule to the pg_proc table was successful but it never executes. Is there a way or a tool to implement versioning of the code of this objects? Help or hints will be gladly appreciated. Cheers, Ezequiel Tolnay etolnay@gbtech.com.au