Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 753DA1337BDE for ; Mon, 7 Mar 2011 07:05:46 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 97609-05 for ; Mon, 7 Mar 2011 11:05:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id 104791337BDD for ; Mon, 7 Mar 2011 07:05:39 -0400 (AST) Received: from [192.168.10.3] (ASte-Genev-Bois-153-1-34-187.w83-200.abo.wanadoo.fr [83.200.24.187]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 3FFEE3B909; Mon, 7 Mar 2011 12:05:39 +0100 (CET) Message-ID: <4D74BC03.2020101@lelarge.info> Date: Mon, 07 Mar 2011 12:05:39 +0100 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); fr; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: Lukasz Brodziak CC: pgsql-admin@postgresql.org Subject: Re: Unable to create function via psql References: <4D74A5E9.7070906@lelarge.info> <4D74B72E.20405@lelarge.info> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201103/73 X-Sequence-Number: 36945 Le 07/03/2011 11:54, Lukasz Brodziak a écrit : > Here it is: http://img69.imageshack.us/i/errorjn.png/ > > Again, when I perform AdminPack.sql in pgAdmin I don't get the error. > You don't do the same thing. If "performing" adminpack.sql is executing it, you also don't have an error with psql when you execute it. At least, the error message displayed has nothing to do with executing the adminpack SQL script. To get back to your error message, it simply says that the pg_file_length(text) function doesn't exist in the database your tool is connected too. So, first, you need to make sure that your tool connects to the database where you added the functions (IOW, where you executed the adminpack script). -- Guillaume http://www.postgresql.fr http://dalibo.com