pg_http urlencode(bytea) considered as different

[fjf2002]

I have installed the https://github.com/pramsey/pgsql-http in the ext_http schema on both servers. Postgrescompare complains about one single function, that is identical on both servers. Dbeaver shows me on both locations

CREATE OR REPLACE FUNCTION ext_http.urlencode(string bytea)
RETURNS text
LANGUAGE c
IMMUTABLE STRICT
AS '$libdir/http', $function$urlencode$function$
;

whereas postgrescompare show me above SQL script just on the destination server; the source server sql is strangely shown as one single empty green line. Postgrescompare suggests to drop the function on the destination server.

Please note that there are two urlencode functions with different arguments. Could that be the problem?

[sql-migrate]

Could be the issue. I'll try recreate.

[fjf2002]

Thank You for your reply.

I noticed that I could delete the function - which should not be possible if postgres had correctly tracked the function as part of an extension, as far as I know(?).
This function was new in the 1.4 version of the extension. Perhaps the upgrade script is somehow wrong?

After dropping and re-creating the extension, the problem does not occur to me any more.

Sorry, this issue does seem to have to do with the extension, not with postgrescompare(?)

You can close the issue.