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.klaver@aklaver.com