I did not re-initdb, just use the old pgdata. I also did not recreate
current database.
Some of the database has value 1 for lanvalidator, some has 2247.
I'll check with the team how the lanvalidator got 1 for the value. I
will report back here.
Thanks,
Soni.
On 23/04/2019 10:51, Tom Lane wr
Soni writes:
> Here it is:
> select * from pg_language;
> lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid |
> laninline | lanvalidator | lanacl
> --+--+-+--+---+---+--+
> internal | 10 | f | f
Fix it, change the lanvalidator value of 1 to the value of fmgr_c_validator.
Thanks a lot Tom, that was fantastic. Not sure how the lanvalidator
value changed to 1.
Thanks,
Soni
On 23/04/2019 10:39, Soni wrote:
Here it is:
select * from pg_language;
lanname | lanowner | lanispl | lanpltrus
Here it is:
select * from pg_language;
lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid |
laninline | lanvalidator | lanacl
--+--+-+--+---+---+--+
internal | 10 | f | f |
Soni writes:
> Here's the backtrace. Please let me know if it helps.
> #4 OidFunctionCall1Coll (functionId=functionId@entry=1,
> collation=collation@entry=0, arg1=arg1@entry=75471) at fmgr.c:1325
hm, there's "function 1" ...
> #5 0x00532054 in ProcedureCreate (procedureName= out>, pr
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
---
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
We have no other extensions installed, just plpgsql.
Here's the backtrace. Please let me know if it helps.
#0 errfinish (dummy=dummy@entry=0) at elog.c:414
#1 0x00820068 in elog_finish (elevel=elevel@entry=20,
fmt=fmt@entry=0x864278 "cache lookup failed for function %u") at elog.c:1376
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 "u
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_c
Soni writes:
> 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] XX000STATEMEN
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-2
12 matches
Mail list logo
