I install the contrib module from the postgres repo using yum install.
creating extension run as postgres superuser.
Thanks,
Soni
On 22/04/2019 21:05, Adrian Klaver wrote:
> 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
>>
>>
>>
>
>