Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aRM0u-0006rc-7p for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 15:40:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aRM0t-0007CY-Qc for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 15:40:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aRLzC-0003iT-Kw for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 15:38:22 +0000 Received: from mail4.neteven.com ([5.135.111.119]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aRLz9-0005OH-8R for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 15:38:21 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail4.neteven.com (Postfix) with ESMTP id 2F2A7A14FE; Thu, 4 Feb 2016 16:38:17 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at mail4.neteven.com Received: from mail4.neteven.com ([127.0.0.1]) by localhost (mail4.neteven.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uZZbGWn_xVh2; Thu, 4 Feb 2016 16:38:17 +0100 (CET) Subject: Re: Postgres 9.5 pg_prewarm To: "Simpson, John (IMS)" , "pgsql-admin@postgresql.org" References: <56B35934.7060209@neteven.com> From: Thomas SIMON Message-ID: <56B3706D.5020309@neteven.com> Date: Thu, 4 Feb 2016 16:38:21 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------080307050909090503060804" X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------080307050909090503060804 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Of course, what a stupid mistake. Must take a coffee :) thanks john Le 04/02/2016 15:27, Simpson, John (IMS) a écrit : > > You need to create the extension in the database that you want to use > it in. From the output that you posted, it looks like you created the > extension in the “postgres” database but you tried to use it in the > “db” database. > > *From:*pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] *On Behalf Of *Thomas SIMON > *Sent:* Thursday, February 04, 2016 8:59 AM > *To:* pgsql-admin@postgresql.org > *Subject:* [ADMIN] Postgres 9.5 pg_prewarm > > Hi all, > > I have just migrated my db to PG 9.5, an I would like to use > pg_prewarm contrib function, but when I want to use it, I have an > error message I don't understand : > > > It should do this : > > > 1.postgres=# select pg_prewarm('foo'); > > 2. pg_prewarm > > 3.------------ > > 4. 113278 > > 5.(1 row) > > > > but it do that : > > psql (9.5.0) > postgres=# create extension pg_prewarm; > CREATE EXTENSION > > db=# select pg_prewarm('accounts'); > ERROR: function pg_prewarm(unknown) does not exist > LINE 1: select pg_prewarm('accounts'); > ^ > HINT: No function matches the given name and argument types. You > might need to add explicit type casts. > > (table accounts exists) > > > Does anyone have an idea ? > > Thanks, > thomas > > > -- > Thomas > > ------------------------------------------------------------------------ > > Information in this e-mail may be confidential. It is intended only > for the addressee(s) identified above. If you are not the > addressee(s), or an employee or agent of the addressee(s), please note > that any dissemination, distribution, or copying of this communication > is strictly prohibited. If you have received this e-mail in error, > please notify the sender of the error. --------------080307050909090503060804 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Of course, what a stupid mistake. Must take a coffee :)

thanks john

Le 04/02/2016 15:27, Simpson, John (IMS) a écrit :

You need to create the extension in the database that you want to use it in. From the output that you posted, it looks like you created the extension in the “postgres” database but you tried to use it in the “db” database.

 

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Thomas SIMON
Sent: Thursday, February 04, 2016 8:59 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Postgres 9.5 pg_prewarm

 

Hi all,

I have just migrated my db to PG 9.5, an I would like to use pg_prewarm contrib function, but when I want to use it, I have an error message I don't understand :


It should do this :


1.       postgres=# select pg_prewarm('foo');  

2.        pg_prewarm  

3.       ------------  

4.            113278  

5.       (1 row) 



but it do that :

psql (9.5.0)
postgres=# create extension pg_prewarm;
CREATE EXTENSION

db=# select pg_prewarm('accounts');
ERROR:  function pg_prewarm(unknown) does not exist
LINE 1: select pg_prewarm('accounts');
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

(table accounts exists)


Does anyone have an idea ?

Thanks,
thomas


-- 
 
Thomas


Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.

--------------080307050909090503060804--