On Tue, 2019-04-23 at 09:15 +0700, Soni wrote: > I install the contrib module from the postgres repo using yum > install. > creating extension run as postgres superuser. > > Thanks, > Soni > 1) Is there a uuid-ossp.control file sitting in the $SHAREDIR/extension path? 2) Does its name exist in pg_available_extensions? 3) Is there a uuid-ossp.so in the lib path? My 2 cents. Cheers Rob > 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 > > > > > > > > > > >
