pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 9.5 pg_prewarm
4+ messages / 3 participants
[nested] [flat]
* Postgres 9.5 pg_prewarm
@ 2016-02-04 13:59 Thomas SIMON <tsimon@neteven.com>
0 siblings, 2 replies; 4+ messages in thread
From: Thomas SIMON @ 2016-02-04 13:59 UTC (permalink / raw)
To: 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 :
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [MASSMAIL]Postgres 9.5 pg_prewarm
@ 2016-02-04 14:09 Gilberto Castillo <gilberto.castillo@etecsa.cu>
parent: Thomas SIMON <tsimon@neteven.com>
1 sibling, 0 replies; 4+ messages in thread
From: Gilberto Castillo @ 2016-02-04 14:09 UTC (permalink / raw)
To: Thomas SIMON <tsimon@neteven.com>; +Cc: 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 :
>
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres 9.5 pg_prewarm
@ 2016-02-04 14:27 Simpson, John (IMS) <SimpsonJ@imsweb.com>
parent: Thomas SIMON <tsimon@neteven.com>
1 sibling, 1 reply; 4+ messages in thread
From: Simpson, John (IMS) @ 2016-02-04 14:27 UTC (permalink / raw)
To: Thomas SIMON <tsimon@neteven.com>; pgsql-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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres 9.5 pg_prewarm
@ 2016-02-04 15:38 Thomas SIMON <tsimon@neteven.com>
parent: Simpson, John (IMS) <SimpsonJ@imsweb.com>
0 siblings, 0 replies; 4+ messages in thread
From: Thomas SIMON @ 2016-02-04 15:38 UTC (permalink / raw)
To: Simpson, John (IMS) <SimpsonJ@imsweb.com>; pgsql-admin
Of course, what a stupid mistake. Must take a coffee :)
thanks john
Le 04/02/2016 15:27, Simpson, John (IMS) a écrit :
>
> 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-02-04 15:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-02-04 13:59 Postgres 9.5 pg_prewarm Thomas SIMON <tsimon@neteven.com>
2016-02-04 14:09 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
2016-02-04 14:27 ` Simpson, John (IMS) <SimpsonJ@imsweb.com>
2016-02-04 15:38 ` Thomas SIMON <tsimon@neteven.com>
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