Re: Issue with postgres 11beta2 and powa on debian stretch amd64

Re: Adrien Nayrat 2018-07-22 <924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info>
> 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 :

Hi,

this is caused by a change between PG11 beta1 and beta2 which causes
several extensions to fail with that error message. Fixed by
recompiling the postgresql-11-powa packages.

> FYI, I do not have this error if I build powa from github's sources. So, I seems
> it is a packing issue.

Additionally, the testsuite was faulty in two ways, firstly it didn't
depend on postgresql-server-dev-all so pg_buildext was not available
which made the for-loop [1] a no-op, and secondly it didn't actually
invoke any functions, so it wouldn't have spotted this problem anyway.
(Now fixed in lines 11-14.)

[1] https://github.com/powa-team/powa-archivist/blob/master/debian/tests/create-extension#L5

Thanks for spotting and reporting!

Christoph