Issue with postgres 11beta2 and powa on debian stretch amd64

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

Responses

Browse pgsql-pkg-debian by date

  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