Installation failure with PostgreSQL v15 (no more pg_atoi)

[robe]

I think this is a PostgreSQL 15 new issue.

Debbie is complaining when compiling against PG 15

17:17:47 gserialized_typmod.c: In function ‘gserialized_typmod_in’:
17:17:47 gserialized_typmod.c:275:19: warning: implicit declaration of function ‘pg_atoi’; did you mean ‘pg_ltoa’? [-Wimplicit-function-declaration]
17:17:47   275 |    int32_t srid = pg_atoi(DatumGetCString(elem_values[i]), sizeof(int32), '\0');
17:17:47       |                   ^~~~~~~
17:17:47       |                   pg_ltoa

17:02:23 psql:/var/lib/jenkins/workspace/postgis/branches/3.3/regress/00-regress-install/share/contrib/postgis/postgis.sql:138: ERROR:  could not load library "/var/lib/jenkins/workspace/postgis/branches/3.3/regress/00-regress-install/lib/postgis-3.so": /var/lib/jenkins/workspace/postgis/branches/3.3/regress/00-regress-install/lib/postgis-3.so: undefined symbol: pg_atoi
17:02:23 -----------------------------------------------------------------------------
17:02:23  failed (Error encountered loading /var/lib/jenkins/workspace/postgis/branches/3.3/regress/00-regress-install/share/contrib/postgis/postgis_comments.sql: /var/lib/jenkins/workspace/postgis/tmp/3_3_pg15w64/regress_log)
17:02:23 -----------------------------------------------------------------------------
17:02:23 NOTICE:  schema "public" already exists, skipping

[laurenz]

Patch to fix the problem

[laurenz]

PostgreSQL ​commit 73508475d69e90f98ebd9b7e1a5933a26a49c5e9 has removed pg_atoi, so building or creating the extension fails.

The attached patch fixes the problem. This should be applied to all branches.

[robe]

Thanks. So this is backward compatible with all supported versions of PostgreSQL right? so safe to backport to 3.2, 3.1, and 3.0

[Regina Obe <lr@…>]

In ae53a53/git:

Fix PG 15 building atoi removed. References #5100 for PostGIS 3.3.0

[Regina Obe <lr@…>]

In e8d1e867/git:

Fix PG 15 building pg_atoi removed. References #5100 for PostGIS 3.2.2

[laurenz]

Yes, that should be safe. All it does is replace the removed function call with the function definition. Thanks for taking care of this!

[Regina Obe <lr@…>]

In f1e799c/git:

Stop using pg_atoi, removed in PG 15
Closes #5100 for PostGIS 3.1.6