PostgreSQL 17 Extension Bugs

Known PostgreSQL 17 problems in extension modules

Extensions that fail to build

• citus: https://github.com/citusdata/citus/issues/7605
• mongo_fdw: https://github.com/EnterpriseDB/mongo_fdw/issues/185
• pg_auto_failover: https://github.com/hapostgres/pg_auto_failover/issues/1048
• pg_bulkload: https://github.com/ossc-db/pg_bulkload/issues/163
• powa: TBD
• redis_fdw: Hold
• repmgr: https://github.com/EnterpriseDB/repmgr/issues/856
• wal2mongo https://github.com/HighgoSoftware/wal2mongo/issues/4

Builds fine, and regression tests fail

• ddlx (pgddl): https://github.com/lacanoid/pgddl/issues/29 (Actually installation also fails)

Already working or fixed

• bgw_replstatus
• count_distinct
• credcheck: https://github.com/MigOpsRepos/credcheck/issues/35
• dbt2
• emaj
• extra_window_functions
• firebird_fdw
• hdfs_fdw: https://github.com/EnterpriseDB/hdfs_fdw/issues/74
• hll
• hypopg
• ip4r
• jsquery
• logerrors: https://github.com/munakoiso/logerrors/issues/27
• login_hook: https://github.com/splendiddata/login_hook/issues/20
• luapgsql
• multicorn2: https://github.com/pgsql-io/multicorn2/issues/55 (as of 3.0)
• mysql_fdw: https://github.com/EnterpriseDB/mysql_fdw/issues/307
• ogr_fdw (pgsql-ogr-fdw) : https://github.com/pramsey/pgsql-ogr-fdw/issues/258
• orafce
• passwordcheck_cracklib
• periods
• pgagent
• pgaudit17: https://github.com/pgaudit/pgaudit/issues/244
• pgauditlogtofile as of 1.6.1: : https://github.com/fmbiete/pgauditlogtofile/issues/42
• pg_background
• pg_bigm
• pgbouncer_fdw
• pg_auth_mon: https://github.com/RafiaSabih/pg_auth_mon/issues/19
• pg_catcheck: https://github.com/EnterpriseDB/pg_catcheck/issues/8
• pg_cron as of 1.6.3 : https://github.com/citusdata/pg_cron/issues/339
• pgcryptokey
• pg_dbms_job
• pg_dbms_lock
• pg_dbms_metadata
• pg_dirtyread
• pgexporter_ext: https://github.com/pgexporter/pgexporter_ext/issues/18
• pg_failover_slots: https://github.com/EnterpriseDB/pg_failover_slots/issues/44
• pg_filedump as of 17.0 : https://github.com/df7cb/pg_filedump/issues/30
• pg_hint_plan: https://github.com/ossc-db/pg_hint_plan/issues/190
• pg_ivm: https://github.com/sraoss/pg_ivm/issues/90
• pg_jobmon
• pgl_ddl_deploy
• pgmemcache
• pgmeminfo
• pgmp
• pglogical: https://github.com/2ndQuadrant/pglogical/issues/478 and https://github.com/2ndQuadrant/pglogical/issues/486
• pg_net
• pg_partman
• pg_permissions
• pg_profile: https://github.com/zubkov-andrei/pg_profile/issues/104
• pg_qualstats: https://github.com/powa-team/pg_qualstats/issues/63
• pg_stat_monitor: https://github.com/percona/pg_stat_monitor/issues/474
• pg_statviz: https://github.com/vyruss/pg_statviz/issues/29
• pg_task: https://github.com/RekGRpth/pg_task/issues/10
• pg_wait_sampling
• pgplsh
• pg_prioritize
• pg_profile: https://github.com/zubkov-andrei/pg_profile/issues/104
• pg_squeeze: https://github.com/cybertec-postgresql/pg_squeeze/issues/75
• pldebugger
• PL/Java: https://github.com/tada/pljava/issues/499
• pllua
• plpgsql_check
• plproxy
• plr: https://github.com/postgres-plr/plr/issues/156
• pointcloud
• postgres-decoderbufs: As of 3.0.1 (and 3.0.2)
• prefix
• rum: https://github.com/postgrespro/rum/issues/127
• safeupdate
• sequential_uuids
• set_user
• sqlite_fdw: https://github.com/pgspider/sqlite_fdw/issues/104 (Fixed with my patch in the pgrpms repo)
• sslutils: https://github.com/EnterpriseDB/sslutils/issues/3
• table_version
• tdigest
• tds_fdw: https://github.com/tds-fdw/tds_fdw/issues/364
• temporal_tables
• timescaledb: https://github.com/timescale/timescaledb/issues/6949
• timestamp9
• topn: https://github.com/citusdata/postgresql-topn/issues/67
• wal2json