Postgres 9.5 pg_prewarm

[Thomas SIMON <tsimon@xxxxxxxxxxx>]

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