Your message dated Tue, 25 Jul 2023 21:32:27 +0000
with message-id <[email protected]>
and subject line Bug#1035921: fixed in postgis 3.1.1+dfsg-1+deb11u2
has caused the Debian Bug report #1035921,
regarding postgresql-13-postgis-3: Inverted x-y-coordinates for EPSG:31466 when
transforming coordinates since 3.1.1+dfsg-1+deb11u1
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1035921: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1035921
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-13-postgis-3
Version: 3.1.1+dfsg-1+deb11u1
Severity: important
Dear Maintainer,
after applying the minor update from 3.1.1+dfsg-1 to 3.1.1+dfsg-1+deb11u1 the
transformation
of coordinates for EPSG:31466 no longer works correctly, the values for x and
y are inverted which broke applications on a production server relying on the
correct order.
This behaviour was probably a unwanted side effect of
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1031392
The steps to reproduce this issue are:
- create a test "bullseye" system (e.g. in vagrant)
- ensure the system is up to date:
`sudo apt update && sudo apt upgrade`
- install Postgres with the PostGIS extensions:
`sudo apt install -y postgresql-13-postgis-3`
- create a test database:
`sudo -u postgres createdb -E UTF8 -T template0 test_db`
- create the PostGIS extension on the test database:
`sudo -u postgres psql -c "CREATE EXTENSION IF NOT EXISTS postgis;" test_db`
- start `psql` and transform a test point from epsg:3857 to epsg:31466
```
sudo -u postgres psql -d test_db
psql (13.10 (Debian 13.10-0+deb11u1))
Type "help" for help.
test_db=# select ST_AsEWKT(ST_Transform(ST_GeomFromEWKT('SRID=3857;POINT(730249
6518693)'), 31466));
st_asewkt
--------------------------------------------------------
SRID=31466;POINT(5586868.886276492 2539841.4544491787)
(1 row)
```
The expected output as from
- PostgresQL 11 with PostGIS 2.5.1+dfsg-1 from Debian Sources
- PostgresQL 11 with PostGIS 2.5.5+dfsg-1.pgdg100+2 from PostgreSQL Sources
- PostgresQL 13 with PostGIS 3.1.1+dfsg-1 from Debian Sources
- PostgresQL 13 with PostGIS 3.3.2+dfsg-1.pgdg110+1 from PostgreSQL Sources
is:
```
sudo -u postgres psql -d test_db
psql (13.10 (Debian 13.10-1.pgdg110+1))
Type "help" for help.
[test_db] # select
ST_AsEWKT(ST_Transform(ST_GeomFromEWKT('SRID=3857;POINT(730249 6518693)'),
31466));
st_asewkt
--------------------------------------------------------
SRID=31466;POINT(2539841.4544491787 5586868.886276492)
(1 row)
```
As one can see, the point values are inverted.
-- System Information:
Debian Release: 11.7
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 5.10.0-20-amd64 (SMP w/4 CPU threads)
Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages postgresql-13-postgis-3 depends on:
ii libc6 2.31-13+deb11u6
ii libgcc-s1 10.2.1-6
ii libgdal28 3.2.2+dfsg-2+deb11u2
ii libgeos-c1v5 3.9.0-1
ii libjson-c5 0.15-2
ii libpcre3 2:8.39-13
ii libproj19 7.2.1-1
ii libprotobuf-c1 1.3.3-1+b2
ii libsfcgal1 1.3.9-2
ii libstdc++6 10.2.1-6
ii libxml2 2.9.10+dfsg-6.7+deb11u4
ii postgresql-13 13.10-0+deb11u1
ii postgresql-13-postgis-3-scripts 3.1.1+dfsg-1+deb11u1
postgresql-13-postgis-3 recommends no packages.
Versions of packages postgresql-13-postgis-3 suggests:
pn postgis <none>
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: postgis
Source-Version: 3.1.1+dfsg-1+deb11u2
Done: Bas Couwenberg <[email protected]>
We believe that the bug you reported is fixed in the latest version of
postgis, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Bas Couwenberg <[email protected]> (supplier of updated postgis package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Thu, 11 May 2023 10:39:28 +0200
Source: postgis
Architecture: source
Version: 3.1.1+dfsg-1+deb11u2
Distribution: bullseye
Urgency: medium
Maintainer: Debian GIS Project <[email protected]>
Changed-By: Bas Couwenberg <[email protected]>
Closes: 1035921
Changes:
postgis (3.1.1+dfsg-1+deb11u2) bullseye; urgency=medium
.
* Add upstream patches to fix axis order regession.
(closes: #1035921)
Checksums-Sha1:
70e07671c93ff08e4cb5f33bc3989859622c510b 2935 postgis_3.1.1+dfsg-1+deb11u2.dsc
3129247cce3fe693d4c4aea6b71d4b3a11196c7e 42568
postgis_3.1.1+dfsg-1+deb11u2.debian.tar.xz
0e51d97d191ea0704db9f8e1b665b5e435b16cf2 19561
postgis_3.1.1+dfsg-1+deb11u2_amd64.buildinfo
Checksums-Sha256:
eb1e791aba4456eaa47e54666278e7dcc515ff347ba7b693ede46b173f165527 2935
postgis_3.1.1+dfsg-1+deb11u2.dsc
2389d4821aaafe27b484d6d0d050a19acce9f127becb99264f6e1bd5a157dc5a 42568
postgis_3.1.1+dfsg-1+deb11u2.debian.tar.xz
88792baa7ff7bf626057dc2ed98bb624777c365d4482525796f56d9cab6a02f9 19561
postgis_3.1.1+dfsg-1+deb11u2_amd64.buildinfo
Files:
e4aa2807a4342e16809bdbd8dbeb409b 2935 misc optional
postgis_3.1.1+dfsg-1+deb11u2.dsc
6dba9a33ce34acb3fe3140858230830f 42568 misc optional
postgis_3.1.1+dfsg-1+deb11u2.debian.tar.xz
d884f2619d7e1b0b92a0d45838bd226f 19561 misc optional
postgis_3.1.1+dfsg-1+deb11u2_amd64.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEgYLeQXBWQI1hRlDRZ1DxCuiNSvEFAmTAByAACgkQZ1DxCuiN
SvHPWBAAiH0jWTH+z20t/sBtMr6ho7xrmqr+vZ4Yf6Z7/Ays/2LhUuiuVCBD6QYC
0ax1MnQoyo/Y8lp46PTkYVuEFFjkORtaEqtqT9pb+zP4fDkOpOj/cdoNpQL4BZGX
1UaMk04CKVms1UDHARuoP1ojGIYW5e5L2kaftTxYQXt8lIHtVsCXXVAZwaw2in9x
vxdCfbAhOPAAWMiMPJq76V0y2+t8ZzfonSnjTQWBSZgXj9+BMGQZgAdBVn2xaybd
sN74esBgXKpTT7pjpvj/+IRXbdYCGMAZsnkRPqQ4bvL/IHLx2JLro6aJ2HmS9XOq
CLk2dtjI+PC3IKkG97dBJs2UxNZFpfZiSyjeLN0snpRzZ54O/2U2UFr2qHtdEVvz
oyMuee/ryyl8cp7bsnNmWgmkzBv0xUO6Ia65AAaesfq0CgjTt8p2QugGV5Nxa/lu
iGH4pEfy62VxXlSk+rks69cd9yOHGmuQkBThmTpQLMOMQYRu37PfMe3reIS+QWAq
bIHrWfo2QAhHihu2iEOcsJHDqb99f//qQOnGJO4/K9AIDDOHHUgxA1BAJQ1zKcmO
xX35jOSnKdl/Bid39CbORRqkE3QBwqYzk+ZuCgl+Y+3pN3mN8HWO2RbqIbuu9s/r
eh9dvgIk/lxcAOJfBLvLOo5tPrNNTNf42X3FZjI4neLhdLdGuxY=
=fKho
-----END PGP SIGNATURE-----
--- End Message ---
