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
