Postgres 9.5 pg_prewarm
От | Thomas SIMON |
---|---|
Тема | Postgres 9.5 pg_prewarm |
Дата | |
Msg-id | 56B35934.7060209@neteven.com обсуждение исходный текст |
Ответы |
Re: [MASSMAIL]Postgres 9.5 pg_prewarm
Re: Postgres 9.5 pg_prewarm |
Список | pgsql-admin |
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 :
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
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 :
- postgres=# select pg_prewarm('foo');
- pg_prewarm
- ------------
- 113278
- (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
В списке pgsql-admin по дате отправления: