Failure during Postgres major version upgrade due to deprecated long_xact funcs

[Kered]

Hi there,

I saw postgres upgrade failure with following message (pg16.1 to 17.0,
postgis 3.4.0 to postgis 3.5.0)

pg_restore: creating FUNCTION "public.checkauth("text", "text", "text")"

pg_restore: creating COMMENT "public.FUNCTION "checkauth"("text", "text",
"text")"

pg_restore: creating FUNCTION "public.checkauthtrigger()"

pg_restore: while PROCESSING TOC:

pg_restore: from TOC entry 558; 1255 18735 FUNCTION checkauthtrigger()
pguser

pg_restore: error: could not execute query: ERROR:  could not find function
"check_authorization" in file
"/local/home/pguser/temp/local_pg/installs/pg170/lib/postgresql/postgis-3.so"

Command was: CREATE FUNCTION "public"."checkauthtrigger"() RETURNS "trigger"

    LANGUAGE "c"

    AS '$libdir/postgis-3', 'check_authorization';


-- For binary upgrade, handle extension membership the hard way

ALTER EXTENSION "postgis" ADD FUNCTION "public"."checkauthtrigger"();


(same for GetTransactionID)


I saw a previous ticket https://trac.osgeo.org/postgis/ticket/5723  which
tried to drop it already, but I still see this. Is this expected or
something that was missed during testing?


Best,

Derek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20241008/39f46fd2/attachment.htm>