X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC14953652 for ; Sun, 10 Apr 2005 00:46:00 +0100 (BST) 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 33818-10 for ; Sat, 9 Apr 2005 23:45:51 +0000 (GMT) Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36]) by svr1.postgresql.org (Postfix) with ESMTP id 82AE553532 for ; Sun, 10 Apr 2005 00:45:50 +0100 (BST) Received: from [192.168.0.2] ([24.201.88.196]) by VL-MO-MR007.ip.videotron.ca (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep 8 2003)) with ESMTP id <0IEP00DOLDXDXM@VL-MO-MR007.ip.videotron.ca> for pgsql-sql@postgresql.org; Sat, 09 Apr 2005 19:44:01 -0400 (EDT) Date: Sat, 09 Apr 2005 19:47:05 -0400 From: Carlos Moreno Subject: Re: Question on triggers and plpgsql In-reply-to: To: pgsql-sql@postgresql.org Message-id: <42586979.3060906@mochima.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040616 References: <4255AA15.8000508@mochima.com> X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/137 X-Sequence-Number: 21030 I think I sent my previous message to John only (sorry!) I just wanted to double check one detail that is not explicitly stated in the documentation for createlang. My question is: can I use createlang on a database that is currently active? That is, a database with plenty of tables that has been and is currently in use? My guess is that there should be no problem and no risk in doing that -- but being my first steps in PL, I wouldn't like to trust a beginner's intuition for a production system. Thanks, Carlos --