From: | Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info> |
---|---|
To: | <pgsql-pkg-debian(at)lists(dot)postgresql(dot)org> |
Subject: | Issue with postgres 11beta2 and powa on debian stretch amd64 |
Date: | 2018-07-22 12:40:36 |
Message-ID: | 924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pkg-debian |
Hello,
I installed postgresql-11-powa on a fresh debian stretch amd64 with
postgresql-11 beta2
I got several errors "set-valued function called in context that cannot accept a
set" which should be fixed :
2018-07-22 14:16:22.209 CEST [30135] WARNING: powa_take_snapshot(): function
"powa_user_functions_snapshot" failed:
state : 0A000
message: set-valued function called in context that cannot
accept a set
detail :
hint :
context: SQL statement "WITH func(dbid, r) AS (
SELECT oid,
powa_stat_user_functions(oid)
FROM pg_database
)
INSERT INTO powa_user_functions_history_current
SELECT dbid, (r).funcid,
ROW(now(), (r).calls,
(r).total_time,
(r).self_time)::powa_user_functions_history_record AS record
FROM func"
PL/pgSQL function powa_user_functions_snapshot() line 10 at SQL statement
SQL statement "SELECT powa_user_functions_snapshot()"
PL/pgSQL function powa_take_snapshot() line 76 at EXECUTE
SQL statement "SELECT powa_take_snapshot()"
FYI, I do not have this error if I build powa from github's sources. So, I seems
it is a packing issue.
Thanks
--
Adrien NAYRAT
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2018-07-22 18:31:26 | Re: Issue with postgres 11beta2 and powa on debian stretch amd64 |
Previous Message | apt.postgresql.org repository | 2018-07-18 11:50:35 | pg-rage-terminator updated to version 0.1.7-1.pgdg+1 |