From: Thomas SIMON <tsimon@neteven.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Postgres 9.5 pg_prewarm
Date: Thu, 4 Feb 2016 14:59:16 +0100
Message-ID: <56B35934.7060209@neteven.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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 :
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tsimon@neteven.com
Subject: Re: Postgres 9.5 pg_prewarm
In-Reply-To: <56B35934.7060209@neteven.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox