Message-ID: <40044.192.168.207.54.1454594998.squirrel@webmail.etecsa.cu>
In-Reply-To: <56B35934.7060209@neteven.com>
References: <56B35934.7060209@neteven.com>
Date: Thu, 4 Feb 2016 09:09:58 -0500 (GMT+5)
Subject: Re: [MASSMAIL]Postgres 9.5 pg_prewarm
From: "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
To: "Thomas SIMON" <tsimon@neteven.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Reply-To: gilberto.castillo@etecsa.cu
User-Agent: SquirrelMail/1.4.8-5.el5_4.10
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit
Importance: Normal
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


> 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 ?
>

Use squeme example... foo.accountes

-- 
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin