MIME-Version: 1.0
From: Chris Sinjakli <sinjo@planetscale.com>
Date: Mon, 8 Sep 2025 18:11:31 +0100
Message-ID: 
 <CABz-y4+1qcFV-jKRHLhQCtREAk4du_5wtTcJU8GFqPHmroxtNw@mail.gmail.com>
Subject: Postgis 3.5.3 packages include 3.6.0 files
To: pgsql-pkg-debian@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001546e4063e4d488d"
Archived-At: 
 <https://www.postgresql.org/message-id/CABz-y4%2B1qcFV-jKRHLhQCtREAk4du_5wtTcJU8GFqPHmroxtNw%40mail.gmail.com>
Precedence: bulk

--0000000000001546e4063e4d488d
Content-Type: text/plain; charset="UTF-8"

Hello,

I'm currently using the 3.5.3 package from
https://apt-archive.postgresql.org/pub/repos/apt bookworm-pgdg-archive main
- specifically 3.5.3+dfsg-1~exp1.pgdg120+1 - and it seems like in the last
week, it has been updated with some files from the 3.6.0 release.

Trying to install the extension from that package results in this error:

postgres=> CREATE EXTENSION postgis;
ERROR:  could not find function "ST_CoverageClean" in file
"/usr/lib/postgresql/17/lib/postgis-3.so"

Specifically, it looks like the package installs the SQL scripts and
control file from 3.6.0:

$ ls /usr/share/postgresql/17/extension/postgis--3.6.0.sql
/usr/share/postgresql/17/extension/postgis--3.6.0.sql

$ cat /usr/share/postgresql/17/extension/postgis-3.control
# postgis extension
comment = 'PostGIS geometry and geography spatial types and functions'
default_version = '3.6.0'
module_pathname = '$libdir/postgis-3'
relocatable = false

Is it possible that a bad version of the 3.5.3 package has been pushed and
overwritten the working one?

Cheers,
Chris

--0000000000001546e4063e4d488d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div>I&#39;m currently using the 3.5.=
3 package from=C2=A0<font face=3D"monospace"><a href=3D"https://apt-archive=
.postgresql.org/pub/repos/apt">https://apt-archive.postgresql.org/pub/repos=
/apt</a> bookworm-pgdg-archive main</font> - specifically=C2=A0<font face=
=3D"monospace">3.5.3+dfsg-1~exp1.pgdg120+1</font> - and it seems like in th=
e last week, it has been updated with some files from the 3.6.0 release.</d=
iv><div><br></div><div>Trying to install the extension from that package re=
sults in this error:</div><div><br></div><div><font face=3D"monospace">post=
gres=3D&gt; CREATE EXTENSION postgis;<br>ERROR: =C2=A0could not find functi=
on &quot;ST_CoverageClean&quot; in file &quot;/usr/lib/postgresql/17/lib/po=
stgis-3.so&quot;</font></div><div><br></div><div>Specifically, it looks lik=
e the package installs the SQL scripts and control file from 3.6.0:</div><d=
iv><br></div><div><font face=3D"monospace">$ ls /usr/share/postgresql/17/ex=
tension/postgis--3.6.0.sql<br>/usr/share/postgresql/17/extension/postgis--3=
.6.0.sql</font></div><div><font face=3D"monospace"><br></font></div><div><f=
ont face=3D"monospace">$ cat /usr/share/postgresql/17/extension/postgis-3.c=
ontrol<br># postgis extension<br>comment =3D &#39;PostGIS geometry and geog=
raphy spatial types and functions&#39;<br>default_version =3D &#39;3.6.0=
9;<br>module_pathname =3D &#39;$libdir/postgis-3&#39;<br>relocatable =3D fa=
lse</font></div><div><br></div><div>Is it possible that a bad version of th=
e 3.5.3 package has been pushed and overwritten the working one?</div><div>=
<br></div><div>Cheers,</div><div>Chris</div><div><br></div><div><br></div><=
/div>

--0000000000001546e4063e4d488d--