#1139519 pgpointcloud: FTBFS: ERROR: function pc_schemaisvalid(text) does not exist

#1139519#5
Date:
2026-06-09 10:29:57 UTC
From:
To:
Dear maintainer:

During a rebuild of all packages in unstable, this package failed to build.

Below you will find the last part of the build log (probably the most
relevant part, but not necessarily). If required, the full build log
is available here:

https://people.debian.org/~sanvila/build-logs/202606/

About the archive rebuild: The build was made on virtual machines from AWS,
using sbuild and a reduced chroot with only build-essential packages.

If you cannot reproduce the bug please contact me privately, as I
am willing to provide ssh access to a virtual machine where the bug is
fully reproducible.

If this is really a bug in one of the build-depends, please use
reassign and add an affects on src:pgpointcloud, so that this is still
visible in the BTS web page for this package.

Thanks.
--------------------------------------------------------------------------------
[...]
 debian/rules clean
dh clean --with autoreconf,pgxs
   debian/rules override_dh_auto_clean
make[1]: Entering directory '/<<PKGBUILDDIR>>'
touch config.mk
dh_auto_clean
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
   dh_clean
   pg_buildext checkcontrol
 debian/rules binary
dh binary --with autoreconf,pgxs
   dh_update_autotools_config
   dh_autoreconf
autoreconf: export WARNINGS=
autoreconf: Entering directory '.'

[... snipped ...]

+LINE 1: SELECT 'pc_id2', PC_PCId(PC_MakePoint(3, ARRAY[-1,-2,-3,-4])...
+                                 ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- Test PC_Compress
 -- Also regression tests for
 -- https://github.com/pgpointcloud/pointcloud/issues/69
@@ -535,77 +503,16 @@
   ('dimensional','auto')
 ) dimcompr(compr,sc)
 ORDER BY compr,sc,v;
- test  | v  |    compr    |   sc    | ok
--------+----+-------------+---------+----
- compr | -7 | dimensional | auto    | t
- compr | -6 | dimensional | auto    | t
- compr | -5 | dimensional | auto    | t
- compr | -4 | dimensional | auto    | t
- compr | -3 | dimensional | auto    | t
- compr | -2 | dimensional | auto    | t
- compr | -1 | dimensional | auto    | t
- compr |  0 | dimensional | auto    | t
- compr |  1 | dimensional | auto    | t
- compr |  2 | dimensional | auto    | t
- compr |  3 | dimensional | auto    | t
- compr |  4 | dimensional | auto    | t
- compr |  5 | dimensional | auto    | t
- compr |  6 | dimensional | auto    | t
- compr |  7 | dimensional | auto    | t
- compr | -7 | dimensional | rle     | t
- compr | -6 | dimensional | rle     | t
- compr | -5 | dimensional | rle     | t
- compr | -4 | dimensional | rle     | t
- compr | -3 | dimensional | rle     | t
- compr | -2 | dimensional | rle     | t
- compr | -1 | dimensional | rle     | t
- compr |  0 | dimensional | rle     | t
- compr |  1 | dimensional | rle     | t
- compr |  2 | dimensional | rle     | t
- compr |  3 | dimensional | rle     | t
- compr |  4 | dimensional | rle     | t
- compr |  5 | dimensional | rle     | t
- compr |  6 | dimensional | rle     | t
- compr |  7 | dimensional | rle     | t
- compr | -7 | dimensional | sigbits | t
- compr | -6 | dimensional | sigbits | t
- compr | -5 | dimensional | sigbits | t
- compr | -4 | dimensional | sigbits | t
- compr | -3 | dimensional | sigbits | t
- compr | -2 | dimensional | sigbits | t
- compr | -1 | dimensional | sigbits | t
- compr |  0 | dimensional | sigbits | t
- compr |  1 | dimensional | sigbits | t
- compr |  2 | dimensional | sigbits | t
- compr |  3 | dimensional | sigbits | t
- compr |  4 | dimensional | sigbits | t
- compr |  5 | dimensional | sigbits | t
- compr |  6 | dimensional | sigbits | t
- compr |  7 | dimensional | sigbits | t
- compr | -7 | dimensional | zlib    | t
- compr | -6 | dimensional | zlib    | t
- compr | -5 | dimensional | zlib    | t
- compr | -4 | dimensional | zlib    | t
- compr | -3 | dimensional | zlib    | t
- compr | -2 | dimensional | zlib    | t
- compr | -1 | dimensional | zlib    | t
- compr |  0 | dimensional | zlib    | t
- compr |  1 | dimensional | zlib    | t
- compr |  2 | dimensional | zlib    | t
- compr |  3 | dimensional | zlib    | t
- compr |  4 | dimensional | zlib    | t
- compr |  5 | dimensional | zlib    | t
- compr |  6 | dimensional | zlib    | t
- compr |  7 | dimensional | zlib    | t
-(60 rows)
-
+ERROR:  function pc_makepoint(integer, double precision[]) does not exist
+LINE 13:   SELECT v, PC_Patch(PC_MakePoint(10, a)) p from points -- u...
+                              ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 SELECT PC_Summary(PC_Compress(PC_Patch(PC_MakePoint(10,ARRAY[1,1,1,1,1,1,1])),
   'dimensional'))::json->'compr';
-   ?column?
----------------
- "dimensional"
-(1 row)
-
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 1: SELECT PC_Summary(PC_Compress(PC_Patch(PC_MakePoint(10,ARRAY...
+                                               ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- https://github.com/pgpointcloud/pointcloud/issues/79
 SELECT '#79' issue,
   PC_PatchMin(p,'x') x_min, PC_PatchMax(p,'x') x_max,
@@ -616,11 +523,10 @@
     PC_Patch( PC_MakePoint(20,ARRAY[-1,0,1]) ),
     'y',0) p
 ) foo;
- issue | x_min | x_max | y_min | y_max | z_min | z_max
--------+-------+-------+-------+-------+-------+-------
- #79   |    -1 |    -1 |     0 |     0 |     1 |     1
-(1 row)
-
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 7:     PC_Patch( PC_MakePoint(20,ARRAY[-1,0,1]) ),
+                      ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- https://github.com/pgpointcloud/pointcloud/issues/78
 SELECT '#78' issue,
   PC_PatchMin(p,'x') x_min, PC_PatchMax(p,'x') x_max,
@@ -632,33 +538,30 @@
     PC_Patch( PC_MakePoint(3,ARRAY[-1,0,4862413,1]) ),
     'y',0) p
 ) foo;
- issue | x_min | x_max | y_min | y_max |  z_min  |  z_max  | i_min | i_max
--------+-------+-------+-------+-------+---------+---------+-------+-------
- #78   |    -1 |    -1 |     0 |     0 | 4862413 | 4862413 |     1 |     1
-(1 row)
-
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 8:     PC_Patch( PC_MakePoint(3,ARRAY[-1,0,4862413,1]) ),
+                      ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- test for PC_BoundingDiagonalAsBinary
 SELECT PC_BoundingDiagonalAsBinary(
 	PC_Patch(ARRAY[
 		PC_MakePoint(1, ARRAY[0.,0.,0.,10.]),
 		PC_MakePoint(1, ARRAY[1.,1.,1.,10.]),
 		PC_MakePoint(1, ARRAY[10.,10.,10.,10.])]));
-                                             pc_boundingdiagonalasbinary
-----------------------------------------------------------------------------------------------------------------------
- \x010200008002000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440
-(1 row)
-
+ERROR:  function pc_makepoint(integer, numeric[]) does not exist
+LINE 3:   PC_MakePoint(1, ARRAY[0.,0.,0.,10.]),
+          ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- test PC_SetPCId
 -- from pcid 1 to 1 (same dimensions, same positions, same compressions)
 -- pcid 1: (X,Y,Z,I), scaled, uncompressed
 SELECT
   PC_AsText(PC_SetPCId(p, 1)) t, PC_Summary(PC_SetPCId(p, 1))::json->'compr' c
 FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1])) p ) foo;
-                    t                    |   c
------------------------------------------+--------
- {"pcid":1,"pts":[[-1,0,4.86241e+06,1]]} | "none"
-(1 row)
-
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 3: FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1]...
+                               ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- test PC_SetPCId
 -- from pcid 1 to 3 (same dimensions, same positions, different compressions)
 -- pcid 1: (X,Y,Z,I), scaled, uncompressed
@@ -666,11 +569,10 @@
 SELECT
   PC_AsText(PC_SetPCId(p, 3)) t, PC_Summary(PC_SetPCId(p, 3))::json->'compr' c
 FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1])) p ) foo;
-                    t                    |       c
------------------------------------------+---------------
- {"pcid":3,"pts":[[-1,0,4.86241e+06,1]]} | "dimensional"
-(1 row)
-
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 3: FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1]...
+                               ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- test PC_SetPCId
 -- from pcid 1 to 4 (different dimensions, different positions, same compressions)
 -- pcid 1: (X,Y,Z,I), scaled, uncompressed
@@ -678,11 +580,10 @@
 SELECT
   PC_AsText(PC_SetPCId(p, 4, 2.0)) t, PC_Summary(PC_SetPCId(p, 4, 2.0))::json->'compr' c
 FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1])) p ) foo;
-                     t                     |   c
--------------------------------------------+--------
- {"pcid":4,"pts":[[2,-1,0,4.86241e+06,2]]} | "none"
-(1 row)
-
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 3: FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1]...
+                               ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- test PC_SetPCId
 -- from pcid 1 to 10 (incompatible dimensions because of different interpretations)
 -- pcid 1: (X,Y,Z,I), scaled, uncompressed
@@ -690,21 +591,23 @@
 SELECT
   PC_AsText(PC_SetPCId(p, 10)) t, PC_Summary(PC_SetPCId(p, 10))::json->'compr' c
 FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1])) p ) foo;
-ERROR:  dimension interpretations are not matching
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 3: FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1]...
+                               ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- test PC_Transform
 SELECT
   PC_AsText(PC_Transform(p, 10, 1.0)) t, PC_Summary(PC_Transform(p, 10, 1.0))::json->'compr' c
 FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1])) p ) foo;
-                  t                   |   c
---------------------------------------+--------
- {"pcid":10,"pts":[[-1,0,1,1,1,1,1]]} | "none"
-(1 row)
-
+ERROR:  function pc_makepoint(integer, integer[]) does not exist
+LINE 3: FROM ( SELECT PC_Patch(PC_MakePoint(1, ARRAY[-1,0,4862413,1]...
+                               ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 -- test PC_Patch from float8 array
 SELECT pc_astext(PC_MakePatch(1, ARRAY[-1,0,5,1, -1,0,6,1, -1,0,7,1]));
-                      pc_astext
------------------------------------------------------
- {"pcid":1,"pts":[[-1,0,5,1],[-1,0,6,1],[-1,0,7,1]]}
-(1 row)
-
+ERROR:  function pc_makepatch(integer, integer[]) does not exist
+LINE 1: SELECT pc_astext(PC_MakePatch(1, ARRAY[-1,0,5,1, -1,0,6,1, -...
+                         ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 TRUNCATE pointcloud_formats;
+ERROR:  relation "pointcloud_formats" does not exist
diff -U3 /<<PKGBUILDDIR>>/pgsql/expected/pointcloud_columns.out /<<PKGBUILDDIR>>/pgsql/results/pointcloud_columns.out
--- /<<PKGBUILDDIR>>/pgsql/expected/pointcloud_columns.out	2023-09-19 18:02:19.000000000 +0000
+++ /<<PKGBUILDDIR>>/pgsql/results/pointcloud_columns.out	2026-06-08 22:02:55.637294920 +0000
@@ -1,13 +1,24 @@
 INSERT INTO pointcloud_formats (pcid, srid) VALUES (777, 666);
+ERROR:  relation "pointcloud_formats" does not exist
+LINE 1: INSERT INTO pointcloud_formats (pcid, srid) VALUES (777, 666...
+                    ^
 CREATE TABLE pc1(p pcpoint);
+ERROR:  type "pcpoint" does not exist
+LINE 1: CREATE TABLE pc1(p pcpoint);
+                           ^
 CREATE TABLE pc2(p pcpoint);
+ERROR:  type "pcpoint" does not exist
+LINE 1: CREATE TABLE pc2(p pcpoint);
+                           ^
 DELETE FROM pointcloud_formats WHERE pcid = 777;
+ERROR:  relation "pointcloud_formats" does not exist
+LINE 1: DELETE FROM pointcloud_formats WHERE pcid = 777;
+                    ^
 SELECT * from pointcloud_columns ORDER BY 1,2,3,4;
- schema | table | column | pcid | srid |  type
---------+-------+--------+------+------+---------
- public | pc1   | p      |      |      | pcpoint
- public | pc2   | p      |      |      | pcpoint
-(2 rows)
-
+ERROR:  relation "pointcloud_columns" does not exist
+LINE 1: SELECT * from pointcloud_columns ORDER BY 1,2,3,4;
+                      ^
 DROP TABLE pc1;
+ERROR:  table "pc1" does not exist
 DROP TABLE pc2;
+ERROR:  table "pc2" does not exist
diff -U3 /<<PKGBUILDDIR>>/pgsql/expected/schema.out /<<PKGBUILDDIR>>/pgsql/results/schema.out
--- /<<PKGBUILDDIR>>/pgsql/expected/schema.out	2023-09-19 18:02:19.000000000 +0000
+++ /<<PKGBUILDDIR>>/pgsql/results/schema.out	2026-06-08 22:02:55.653294921 +0000
@@ -1,8 +1,7 @@
 -- See https://github.com/pgpointcloud/pointcloud/issues/71
 set client_min_messages to ERROR;
 select '#71', PC_SchemaIsValid('<xml/>'::xml::text);
- ?column? | pc_schemaisvalid
-----------+------------------
- #71      | f
-(1 row)
-
+ERROR:  function pc_schemaisvalid(text) does not exist
+LINE 1: select '#71', PC_SchemaIsValid('<xml/>'::xml::text);
+                      ^
+HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
+ [ little != big ]
+ [ amd64 != armhf ]
+ exit 1
make[1]: *** [debian/rules:28: override_dh_pgxs_test] Error 1
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
make: *** [debian/rules:48: binary] Error 2
dpkg-buildpackage: error: debian/rules binary subprocess failed with exit status 2
--------------------------------------------------------------------------------

#1139519#8
Date:
2026-06-15 15:23:05 UTC
From:
To:
Hello,

Bug #1139519 in pgpointcloud reported by you has been fixed in the
Git repository and is awaiting an upload. You can see the commit
message below and you can check the diff of the fix at:

https://salsa.debian.org/postgresql/pgpointcloud/-/commit/67768f54d4b3c8e5b93ffd8c081f8e2e20218f2f

(this message was generated automatically)
-- 
Greetings

https://bugs.debian.org/1139519

#1139519#15
Date:
2026-06-15 15:34:28 UTC
From:
To:
We believe that the bug you reported is fixed in the latest version of
pgpointcloud, 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 1139519@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Christoph Berg <myon@debian.org> (supplier of updated pgpointcloud 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 ftpmaster@ftp-master.debian.org)
Format: 1.8
Date: Mon, 15 Jun 2026 17:19:53 +0200
Source: pgpointcloud
Architecture: source
Version: 1.2.5-4
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Changed-By: Christoph Berg <myon@debian.org>
Closes: 1139519
Changes:
 pgpointcloud (1.2.5-4) unstable; urgency=medium
 .
   * Fix path to extension at test time. (Closes: #1139519)
Checksums-Sha1:
 9bab6beb308191a550244c5a39b5ede094f7450e 2179 pgpointcloud_1.2.5-4.dsc
 97fdbc2b52033c39a0ddf00f2d95da47ad078cdc 4024 pgpointcloud_1.2.5-4.debian.tar.xz
Checksums-Sha256:
 10dde89f6413a6cdc3f08b6af56cc5e7c0f0f0a2ebd9b26d56bc44bbda0db171 2179 pgpointcloud_1.2.5-4.dsc
 3e689712117053c18a12251b854620b9ecd6c7c5d20dc6a7e23a6561196b1388 4024 pgpointcloud_1.2.5-4.debian.tar.xz
Files:
 a1441bb0d93cca5380e9dd694f4f2d8e 2179 database optional pgpointcloud_1.2.5-4.dsc
 66f818ffa1cb03c70629ec50a14e0fe3 4024 database optional pgpointcloud_1.2.5-4.debian.tar.xz
-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAmowGxoACgkQTFprqxLS
p67AQxAAraaHYB/FRs7aAMr/39WVeRo5/nE/3PusRMjzT/AKVBh1lNJ8hfkXqY9F
vrEVYJCcHlvEvOebsyFquCdMVRhWQw/NkDN78Imj0KJTpmgNlkLklM2ig+691GVL
T9IDkWIBM/I7xeygueFLtGMLg6hYu+ac0qWPr2p/annfcFMAXmGkS2xYsSo+ECXW
0RwQRAKgBnHoNpREYs9chs8WgNbrON9c1ceYNNGeSnZSVunMy3hxVzjXWxw990xb
3TDkAGKPdfo8wS9c+/zEy0ULs4VEfOKh6wNhyp7OCMNAO2ry7a20bw/eZgLYxLCP
P/StHAe1UFzV6IxfM5bcX6oeQflTN22GuvD2OrVpKlC/SnkNPhnHmio2Zi7cyEGg
ZaB3qRom2yKOhlPoiWJ8UYbqpVlnRWuhEFZPZUMcFJ34Ir0Z+52r3R/0jQsFgO4G
qz/s28IBwbLuivyDukxDrEzxiX7n7k9Y/u3y/RO8IL/WrnPmi4bJZHGNkiYaCkt5
4DEL/A7ZL4AqxQgZrshgIO8XAQBOJWLf2hFvlmId/W84lqgQihttoCWJP/rIQS2l
9mkfouLWAr4ouiM8MgFGvYbg2psS/dzx8EhRWQzRKFLrKMP7H+sw+de7QhPYPzWN
vqZMTafJi1JPqLFP8H7RVdJXbPskYShhNNh0P3nrUglhn9fYKWs=
=EhBL
-----END PGP SIGNATURE-----