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
> > >
> > >
> > >
>
>