Issue with postgres 11beta2 and powa on debian stretch amd64 - Mailing list pgsql-pkg-debian

From Adrien Nayrat
Subject Issue with postgres 11beta2 and powa on debian stretch amd64
Date
Msg-id 924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info
Whole thread Raw
Responses Re: Issue with postgres 11beta2 and powa on debian stretch amd64
List 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



Attachment

pgsql-pkg-debian by date:

Previous
From: apt.postgresql.org repository
Date:
Subject: pg-rage-terminator updated to version 0.1.7-1.pgdg+1
Next
From: Christoph Berg
Date:
Subject: Re: Issue with postgres 11beta2 and powa on debian stretch amd64