[Pkg-postgresql-public] [pgsql-pkg-debian] Debian packaging of the q3c and pgsphere extensions

[Christoph Berg]

Re: Ole Streicher 2017-08-17 <bb2ca0c2-8c3b-c13f-fa4d-f935560497fd at debian.org>
> Markus replied to me and reminded me that I shouldn't use the tarball
> but the current git repository for the moment.
> 
> What I did, resulting in successful tests. Since Lintian didn't complain
> (and for me personally everything looks good), I uploaded the package;
> it should appear on NEW soon (which has a long queue in the moment,
> unfortunately).
> 
> Thank you very much for the help, and I am open for more comments :-)

Hi,

nice :)

I've just triggered a build on the apt.postgresql.org jenkins.
Unfortunately, pgsphere is failing the regression tests on ppc64el due
to floating point differences (e.g. 0 vs -2.38158728306e-17). This is
likely just different rounding, but this looks like a real bug:

00:01:42.739   SELECT '( 0h 2m 30s ,-90d 0m 0s)'::spoint;
00:01:42.739 !             spoint            
00:01:42.739 ! ------------------------------
00:01:42.739 !  (  0d 37m 30s , -90d  0m 0s)

00:01:42.743   SELECT '( 0h 2m 30s ,-90d 0m 0s)'::spoint;
00:01:42.743 !                 spoint                
00:01:42.743 ! --------------------------------------
00:01:42.743 !  (  0d 37m 30s , - 0d  0m -82620000s)

The full build logs are at
https://pgdgbuild.dus.dg-i.net/job/pgsphere-binaries/1/
https://pgdgbuild.dus.dg-i.net/job/pgsphere-binaries/1/architecture=ppc64el,distribution=sid/console

(Needs a certificate from sso.debian.org for access)

Christoph