Re: cache lookup failed for function 1 on fmgr_info_cxt_security, fmgr.c:184

On 4/21/19 9:14 PM, Soni wrote:
> Hello All,
>
> CentOS Linux release 7.5.1804 (Core)
> Postgres 10.7.
>
> When "create extension "uuid-ossp"", I got :
> 2019-04-22 02:41:53.323 UTC [10305] XX000ERROR:  XX000: cache lookup
> failed for function 1
> 2019-04-22 02:41:53.323 UTC [10305] XX000LOCATION:
> fmgr_info_cxt_security, fmgr.c:184
> 2019-04-22 02:41:53.323 UTC [10305] XX000STATEMENT:  create extension
> "uuid-ossp" ;
> I tried reinstall contrib module and even all postgres component, but
> still no luck.
> Try restarting the server also but no luck.
> Any idea how to resolve this ?

How and where are you installing Postgres and -contrib from?

Is the user you are running CREATE EXTENSION a superuser?

>
> Thanks,
> Soni
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com