Bug#1139157: Bug: postgis: Null-byte (\x00) in postgis--3.5.2.sql causes CREATE EXTENSION to fail

[Roland Wagner]

Package: postgis

Version: 3.5.2+dfsg-1

Severity: important

Architecture: arm64

 

Dear Maintainer,

 

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:

 

ERROR: invalid byte sequence for encoding "UTF8": 0x00

 

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

 

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

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

 

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

 

Workaround:

Removing the null-byte with 'tr -d "\000"' and manually fixing the resulting
unterminated string/syntax errors at the end of the file allowed the
extension to load successfully. 

 

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

 

Best regards,

Roland Wagner

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

[Dein Name]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-grass-devel/attachments/20260606/b1c8d0bf/attachment.htm>