Re: [MASSMAIL]Postgres 9.5 pg_prewarm
От
Gilberto Castillo
Тема
Re: [MASSMAIL]Postgres 9.5 pg_prewarm
Дата
Msg-id
40044.192.168.207.54.1454594998.squirrel@webmail.etecsa.cu
Ответ на
Postgres 9.5 pg_prewarm (Thomas SIMON)
Список
Дерево обсуждения
Postgres 9.5 pg_prewarm Thomas SIMON <tsimon@neteven.com>
Re: [MASSMAIL]Postgres 9.5 pg_prewarm "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
Re: Postgres 9.5 pg_prewarm "Simpson, John (IMS)" <SimpsonJ@imsweb.com>
Re: Postgres 9.5 pg_prewarm Thomas SIMON <tsimon@neteven.com>
> 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
В списке pgsql-admin по дате отправления