Yes for that three questions.
-bash-4.2$ ls /usr/pgsql-10/share/extension/uuid-ossp.control
/usr/pgsql-10/share/extension/uuid-ossp.control
select * from pg_available_extensions where name = 'uuid-ossp';
name | default_version | installed_version |
comment
-----------+-----------------+-------------------+-------------------------------------------------
uuid-ossp | 1.1 | | generate universally
unique identifiers (UUIDs)
(1 row)
-bash-4.2$ ls /usr/pgsql-10/lib/uuid-ossp.so
/usr/pgsql-10/lib/uuid-ossp.so
Thanks,
Soni
On 23/04/2019 10:05, rob stone wrote:
>
> 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
>>>>
>>>>
>>>>
>>
