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

On 07/22/2018 08:31 PM, Christoph Berg wrote:
> 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.)

Thanks!

> 
> [1] https://github.com/powa-team/powa-archivist/blob/master/debian/tests/create-extension#L5
> 
> Thanks for spotting and reporting!
> 
> Christoph
>