Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aRKT2-00029l-1v for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:01:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aRKT1-0004xg-HC for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:01:03 +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 1aRKRK-0001w1-Sw for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 13:59:19 +0000 Received: from mail4.neteven.com ([5.135.111.119]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aRKRH-00037P-Ke for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 13:59:17 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail4.neteven.com (Postfix) with ESMTP id 31973A14FE for ; Thu, 4 Feb 2016 14:59:13 +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 6MdrRbhaOBZN for ; Thu, 4 Feb 2016 14:59:13 +0100 (CET) To: "pgsql-admin@postgresql.org" From: Thomas SIMON Subject: Postgres 9.5 pg_prewarm Message-ID: <56B35934.7060209@neteven.com> Date: Thu, 4 Feb 2016 14:59:16 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------030408050007090108030206" 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. --------------030408050007090108030206 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit 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 --------------030408050007090108030206 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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
--------------030408050007090108030206--