From: Simpson, John (IMS) <SimpsonJ@imsweb.com>
To: Thomas SIMON <tsimon@neteven.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgres 9.5 pg_prewarm
Date: Thu, 4 Feb 2016 14:27:06 +0000
Message-ID: <a5198320e3e342b0a5063628efda4b04@NAIAD.omni.imsweb.com> (raw)
In-Reply-To: <56B35934.7060209@neteven.com>
References: <56B35934.7060209@neteven.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
You need to create the extension in the database that you want to use it in. From the output that you posted, it looks like you created the extension in the “postgres” database but you tried to use it in the “db” database.
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Thomas SIMON
Sent: Thursday, February 04, 2016 8:59 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Postgres 9.5 pg_prewarm
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
________________________________
Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.
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: SimpsonJ@imsweb.com, tsimon@neteven.com
Subject: Re: Postgres 9.5 pg_prewarm
In-Reply-To: <a5198320e3e342b0a5063628efda4b04@NAIAD.omni.imsweb.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