[From nobody Sat Jun  6 19:31:10 2026
Received: (at submit) by bugs.debian.org; 6 Jun 2026 18:05:42 +0000
X-Spam-Checker-Version: SpamAssassin 4.0.1-bugs.debian.org_2005_01_02
 (2024-03-25) on buxtehude.debian.org
X-Spam-Level: 
X-Spam-Status: No, score=-17.1 required=4.0 tests=BAYES_00,
 BODY_INCLUDES_PACKAGE,BODY_INCLUDES_SEVERITY,DKIM_SIGNED,DKIM_VALID,
 DKIM_VALID_AU,DKIM_VALID_EF,FOURLA,HAS_PACKAGE,HTML_MESSAGE,MULTALT,
 NEXTPART,RCVD_IN_DNSWL_NONE,SPF_HELO_NONE,SPF_PASS,VERSION
 autolearn=ham autolearn_force=no
 version=4.0.1-bugs.debian.org_2005_01_02
X-Spam-Bayes: score:0.0000 Tokens: new, 117; hammy, 122; neutral, 42; spammy,
 8. spammytokens:0.999-1--Dein, 0.999-+--H*x:Outlook,
 0.999-+--H*UA:Outlook, 0.999-+--H*x:Microsoft, 0.999-+--H*UA:Microsoft
 hammytokens:0.000-+--trixie, 0.000-+--Trixie, 0.000-+--dfsg-1,
 0.000-+--dfsg1, 0.000-+--Maintainer
Return-path: &lt;w@gner.org&gt;
Received: from mout.kundenserver.de ([217.72.192.75]:38581)
 by buxtehude.debian.org with esmtps
 (TLS1.3:ECDHE_SECP256R1__RSA_PSS_RSAE_SHA256__AES_256_GCM:256)
 (Exim 4.96) (envelope-from &lt;w@gner.org&gt;) id 1wVvOv-004AWS-10
 for submit@bugs.debian.org; Sat, 06 Jun 2026 18:05:42 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gner.org;
 s=s1-ionos; t=1780769138; x=1781373938; i=w@gner.org;
 bh=JtGMRR9T7GR+hrNLk9V3vmowT8GukQXoUC2+mso+Br0=;
 h=X-UI-Sender-Class:From:To:Subject:Date:Message-ID:MIME-Version:
 Content-Type:cc:content-transfer-encoding:content-type:date:from:
 message-id:mime-version:reply-to:subject:to;
 b=wERXh9wciWU9npimZAXgYh03CUMFDcb70v16pCeW/lmh/xmv1Skt9du6BrJWXkfS
 glW4z7hcjm1axiq2/K6ns7i+UBi7aYbG+1pF4i9eqXUT4XnZqfCczS3TJUp5kz+QR
 I4NcbxPljoPOeaSAcEQQbrw50Mpws2WJzI2QiG5KAvZZE15KzGTf7NRzWzTLAHmoM
 oeLsNvCO4VyN2BPX7Td9VT3//bnmasPTTwEOjb6ee7l+TsxwYmQTxNVlCSK/x1veM
 QC6MciVCk7yi/o0uQUk55UVALJKjyGV81Fm/acFbyFdUV7efIwVxeRgWQCnNlbnoi
 2b163xY1W3hRPMYoTQ==
X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6
Received: from client.hidden.invalid by mrelayeu.kundenserver.de (mreue108
 [212.227.15.183]) with ESMTPSA (Nemesis) id 1MXoxG-1wk9ii3l3U-00NrB6 for
 &lt;submit@bugs.debian.org&gt;; Sat, 06 Jun 2026 19:52:52 +0200
From: &quot;Roland Wagner&quot; &lt;w@gner.org&gt;
To: &lt;submit@bugs.debian.org&gt;
Subject: Bug: postgis: Null-byte (\x00) in postgis--3.5.2.sql causes CREATE
 EXTENSION to fail
Date: Sat, 6 Jun 2026 19:52:52 +0200
Message-ID: &lt;01a301dcf5dd$4c0ead00$e42c0700$@gner.org&gt;
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary=&quot;----=_NextPart_000_01A4_01DCF5EE.0F9951C0&quot;
X-Mailer: Microsoft Outlook 16.0
Thread-Index: Adz13Sl7AVkAKbzISoiNRKXf2I0ouA==
Content-Language: de
X-Provags-ID: V03:K1:BcZXhAr5PpW3Emgb3xlnl7sztmWHuiubxcjCyPPvFe9ZFDsqkvr
 Yd8w9FeoYcEEedSWKjvjlGGrbN4BOTRUcZvWzBkocDl0wuW4tijAmMvtBdcG3Xxg41ejTIf
 dGyE6eZzFPDuUcoIvhfb3bq3/E+w34JuSmpDDi6JcU8K+4PqvUobZjvexCTRpvzwaYQWiCA
 1tWFU6q7NLtHy/cyErldA==
UI-OutboundReport: notjunk:1;M01:P0:H4nBRBjBzvM=;/UHvQ7ir8wlRopzXVuOLuKOP8xh
 ZciTfDVQMqlQRMDRcYHrt0w4w14CBvh7LB7CoApkmaoorsQaS0lsX4zeMZrWQSjsxsNp/W/Mo
 2ide627lZKtHBWptIzqiyGKIeQoMYRGkqNa+nCTQ/AJ3p8wokFk6Jf1SkWR42ZtKiIeqHwf/B
 nDHUUHd47h9NhuNkSX4kN34c+NFb6/ckF9Ct/+up/bdY0FRo3SlilkvunfRo6NJEehwtyVBVN
 o8QLdCjJoE/DYccpphrt8ZkNkCf+RD2wNxVkTYFI0pS/dcFInXwEeh447vZwY8/yzHiDpVAPm
 6eLAEKZJswCeD2QSZnxNzTU8nZ5lLB1qd/2im5BuiWKzuCJf7R8lWjmR6QknKKiMwOzJyYEd2
 raA6MBcgAQs4Nb2kSm18dnJppnWmqcA4BGURzSIzIQchYwK8b/wgKQkg9p1GesTxG+Ml0V2Gh
 2gThfrDuaw/SXhDfBem82OWA4VWC8VE041vRPZHNhef87sFfCqNZNq0AEjw+V2YFwwmk19VXB
 WXjD3HRdNaaLUA9AnG2C4zb46ot2SfOdmteVVKesOnKuJ4h8kN9YOrqflM3G3a0FYLfr7XaBd
 FFGkNC8bTxQ0rQi/4GaL5mnYNgQG64sFrfZfKlm56GHmSvMpzP7CdprjRtB0mFdJ82tQ62rLx
 i3Y2iXVij484Pa3rcDCkVAmHuYZjIopuqQzoM1ZD5bGDJFK97wCX8GQcOfeApeD7wGjCqiUDs
 Ij9xvpLpaCtJhkh3euvwXv/+HTDibGU8tB3jyET8Em2aEGFQUDc9WvoIkouQ4O9N5mIxww56j
 MAbpDjhJZHvEuNnY+m5SUQvgQuOMLts2WyYZAmVnzJztDub+ZyGOh0Sqbc1tCe3bzYfEsDPcg
 dT81pthLI8AdOp3BfjXs2CENdsT18YP5WXvNvFYbT9sDbomGd4l4wY3ptfVw+FiKt+E99yILG
 bPNyeK4kn/qVCtBTtULbV3Z787Et+as02r7Y3Xkpvd3AFHiKRtPTa9t6Cigx4HedbZB3DGXqo
 osqde9d+hsKduLxuS09YrPdxLp1WXfyQDLaVN4WeovNPDk/GB6teRE4PDSnWcJ/IgO+SjUOro
 S1CfQG7TV9ipF0e8VI+H/k+LKTqpbttUVFdyIz96JI6uhxxak1SnJsIWfwvSni8PxhpkoOpux
 vcbfswPS+5cogwb/Ai6IrnpVkXgHGwhaeeKZObNyUdciriI6nLUnEWlHGwZ/RIwu7g8q0VjfZ
 U5QnlN86RJs5ZAZd1kf+1pYAkjbkY4hkZwpDRwoKKuxUBe42kXGJ/LW/zOC4TOLoNq7U2Tv7O
 Utt8VFnzNNNNWZqnHCttQA89HE112N8dR+IKvbikWyMT1+dcuEehBWnlG7d5gQzK7+XLJ0knD
 Izlfp+HiIq/2vSCWtUoVLcPPaF6hsRJU90gM5MJ2Bx63ou1PYDRPlADqx7PBsUYP/YzAMLrZp
 sEhFA8NYBIRedhZ0Onf9E+zuLWKgaSpk+5t1uqxtxcM1M1KrJklVrhtiPlE/hs2poAdDGaDWL
 ETeitFR1Mhj1CYNZgiXL5M9uPhXThy/3aQxyNPNX6y5KbhdeiuggHqL8dJLgQgUxTrSoxJW45
 xxS8eDfPNtqZkcJ+WNWXPaj1MkTifMKpTqO+X8fgZo+VfTtUfDiE42cQCRlJ8Pu6P6ZMfgvHG
 rkmwhfE9JLyI6BkiTWhuFiGDEWZGZDLa8EQIyPWD/Gqv4iRXa3fKk3FZ01CcMW5yBO6PR9Rl9
 /PdsToLK2zeWc/0owPCBn/FHN/ZRa4wn1irYrFpDWQ6B56eo1Ts03fhwFnnljY19FxqO+7bvA
 +WV+OllE1N2nrZy5IdXAWZVuw48SX0zfZsBZbIun3gtLy7hLUy4KnEfwzsNGeONJoWxozTpYr
 c/YTk3594Kyi5SxGaBszh4/jbJExjr9mwjNF7ODpOcf32WVMWE/+TawSkYb
X-Greylist: delayed 764 seconds by postgrey-1.37 at buxtehude;
 Sat, 06 Jun 2026 18:05:41 UTC
Delivered-To: submit@bugs.debian.org

This is a multipart message in MIME format.

------=_NextPart_000_01A4_01DCF5EE.0F9951C0
Content-Type: text/plain;
	charset=&quot;us-ascii&quot;
Content-Transfer-Encoding: quoted-printable

Package: postgis

Version: 3.5.2+dfsg-1

Severity: important

Architecture: arm64

=20

Dear Maintainer,

=20

When trying to enable the PostGIS extension on a fresh PostgreSQL 17
installation running on Debian Trixie (arm64 / Raspberry Pi 5), the databa=
se
throws the following error:

=20

ERROR: invalid byte sequence for encoding &quot;UTF8&quot;: 0x00

=20

We tracked this down to a physical null-byte (\x00) inside the SQL extensi=
on
script provided by the package.

=20

File: /usr/share/postgresql/17/extension/postgis--3.5.2.sql

Location: Inside the definition string for EPSG 8796 (around the string
&quot;AUTHORITY[&quot;EPSG&quot;,&quot;42&quot;)

=20

Running the following command confirms the physical presence of the
null-byte in the file:

grep -Pa '\x00' /usr/share/postgresql/17/extension/postgis--3.5.2.sql

=20

Workaround:

Removing the null-byte with 'tr -d &quot;\000&quot;' and manually fixing the resulti=
ng
unterminated string/syntax errors at the end of the file allowed the
extension to load successfully.=20

=20

It seems there was a compilation or packaging error when building this
specific version for arm64.

=20

Best regards,

Roland Wagner

Gemini helped me, its really a great tool. Many thanks also to you, becaus=
e
you maintain also a great tool!

[Dein Name]


------=_NextPart_000_01A4_01DCF5EE.0F9951C0
Content-Type: text/html;
	charset=&quot;us-ascii&quot;
Content-Transfer-Encoding: quoted-printable

&lt;html xmlns:o=3D&quot;urn:schemas-microsoft-com:office:office&quot; =
xmlns:w=3D&quot;urn:schemas-microsoft-com:office:word&quot; =
xmlns:m=3D&quot;http://schemas.microsoft.com/office/2004/12/omml&quot; =
xmlns=3D&quot;http://www.w3.org/TR/REC-html40&quot;&gt;&lt;head&gt;&lt;meta =
http-equiv=3DContent-Type content=3D&quot;text/html; =
charset=3Dus-ascii&quot;&gt;&lt;meta name=3DGenerator content=3D&quot;Microsoft Word 15 =
(filtered medium)&quot;&gt;&lt;style&gt;&lt;!--
/* Font Definitions */
@font-face
	{font-family:&quot;Cambria Math&quot;;
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:&quot;Calibri&quot;,sans-serif;
	mso-ligatures:standardcontextual;
	mso-fareast-language:EN-US;}
span.E-MailFormatvorlage17
	{mso-style-type:personal-compose;
	font-family:&quot;Calibri&quot;,sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--&gt;&lt;/style&gt;&lt;/head&gt;&lt;body lang=3DDE link=3D&quot;#0563C1&quot; vlink=3D&quot;#954F72&quot; =
style=3D'word-wrap:break-word'&gt;&lt;div class=3DWordSection1&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;Package: =
postgis&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;Version: 3.5.2+dfsg-1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;Severity: =
important&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;Architecture: arm64&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;Dear =
Maintainer,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;When trying to enable the PostGIS extension on a fresh =
PostgreSQL 17 installation running on Debian Trixie (arm64 / Raspberry =
Pi 5), the database throws the following error:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;ERROR: invalid byte sequence for =
encoding &quot;UTF8&quot;: 0x00&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;We tracked this down to a physical =
null-byte (\x00) inside the SQL extension script provided by the =
package.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;File: =
/usr/share/postgresql/17/extension/postgis--3.5.2.sql&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/=
p&gt;&lt;p class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;Location: Inside the =
definition string for EPSG 8796 (around the string =
&quot;AUTHORITY[&quot;EPSG&quot;,&quot;42&quot;)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;Running the following command =
confirms the physical presence of the null-byte in the =
file:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;grep =
-Pa '\x00' =
/usr/share/postgresql/17/extension/postgis--3.5.2.sql&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/=
p&gt;&lt;p class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;Workaround:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;Removing the null-byte with 'tr -d =
&quot;\000&quot;' and manually fixing the resulting unterminated =
string/syntax errors at the end of the file allowed the extension to =
load successfully. &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;It seems there was a compilation or packaging error when =
building this specific version for arm64.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;&lt;o:p&gt;&nbsp;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;Best regards,&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;Roland Wagner&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;&lt;p class=3DMsoNormal&gt;&lt;span =
lang=3DEN-GB&gt;Gemini helped me, its really a great tool. Many thanks also =
to you, because you maintain also a great tool!&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p =
class=3DMsoNormal&gt;&lt;span lang=3DEN-GB&gt;[Dein =
Name]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;/body&gt;&lt;/html&gt;
------=_NextPart_000_01A4_01DCF5EE.0F9951C0--
]