postgresql17 needs MacPorts flex on < 10.6

[barracuda156]

Fails to configure on 10.5.8:

--->  Configuring postgresql17
Executing:  cd "/opt/local/var/macports/build/postgresql17-098f9924/work/postgresql-17.5" && ./configure --prefix=/opt/local PG_SYSROOT=disabled ZIC=/opt/local/var/macports/build/postgresql17-098f9924/work/postgresql-17.5/src/timezone/zic --sysconfdir=/opt/local/etc/postgresql17 --bindir=/opt/local/lib/postgresql17/bin --libdir=/opt/local/lib/postgresql17 --includedir=/opt/local/include/postgresql17 --datadir=/opt/local/share/postgresql17 --docdir=/opt/local/share/doc/postgresql17 --mandir=/opt/local/share/doc/postgresql17/man --with-includes=/opt/local/include --with-libraries=/opt/local/lib --with-openssl --with-bonjour --with-readline --with-zlib --with-lz4 --with-zstd --with-libxml --with-libxslt --with-gssapi --with-uuid=e2fs --with-icu 
checking build system type... powerpc-apple-darwin9.8.0
checking host system type... powerpc-apple-darwin9.8.0
checking which template to use... darwin
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 8kB
checking for segment size... 1GB
checking for WAL block size... 8kB
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables... 
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether /usr/bin/gcc-4.2 accepts -g... yes
checking for /usr/bin/gcc-4.2 option to accept ISO C89... none needed
checking for /usr/bin/gcc-4.2 option to accept ISO C99... -std=gnu99
checking whether we are using the GNU C++ compiler... yes
checking whether /usr/bin/g++-4.2 accepts -g... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wdeclaration-after-statement, for CFLAGS... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Werror=vla, for CFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Werror=unguarded-availability-new, for CFLAGS... no
checking whether /usr/bin/g++-4.2 supports -Werror=unguarded-availability-new, for CXXFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wendif-labels, for CFLAGS... yes
checking whether /usr/bin/g++-4.2 supports -Wendif-labels, for CXXFLAGS... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wmissing-format-attribute, for CFLAGS... yes
checking whether /usr/bin/g++-4.2 supports -Wmissing-format-attribute, for CXXFLAGS... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wimplicit-fallthrough=3, for CFLAGS... no
checking whether /usr/bin/g++-4.2 supports -Wimplicit-fallthrough=3, for CXXFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wcast-function-type, for CFLAGS... no
checking whether /usr/bin/g++-4.2 supports -Wcast-function-type, for CXXFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wshadow=compatible-local, for CFLAGS... no
checking whether /usr/bin/g++-4.2 supports -Wshadow=compatible-local, for CXXFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wformat-security, for CFLAGS... yes
checking whether /usr/bin/g++-4.2 supports -Wformat-security, for CXXFLAGS... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -fno-strict-aliasing, for CFLAGS... yes
checking whether /usr/bin/g++-4.2 supports -fno-strict-aliasing, for CXXFLAGS... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -fwrapv, for CFLAGS... yes
checking whether /usr/bin/g++-4.2 supports -fwrapv, for CXXFLAGS... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -fexcess-precision=standard, for CFLAGS... no
checking whether /usr/bin/g++-4.2 supports -fexcess-precision=standard, for CXXFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -funroll-loops, for CFLAGS_UNROLL_LOOPS... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -ftree-vectorize, for CFLAGS_VECTORIZE... yes
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wunused-command-line-argument, for NOT_THE_CFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wcompound-token-split-by-macro, for NOT_THE_CFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wformat-truncation, for NOT_THE_CFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wstringop-truncation, for NOT_THE_CFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -Wcast-function-type-strict, for NOT_THE_CFLAGS... no
checking whether /usr/bin/gcc-4.2 -std=gnu99 supports -fvisibility=hidden, for CFLAGS_SL_MODULE... yes
checking whether /usr/bin/g++-4.2 supports -fvisibility=hidden, for CXXFLAGS_SL_MODULE... yes
checking whether /usr/bin/g++-4.2 supports -fvisibility-inlines-hidden, for CXXFLAGS_SL_MODULE... yes
checking whether the C compiler still works... yes
checking how to run the C preprocessor... /usr/bin/gcc-4.2 -std=gnu99 -E
checking for pkg-config... /opt/local/bin/pkg-config
checking pkg-config is at least version 0.9.0... yes
checking whether to build with ICU support... yes
checking for icu-uc icu-i18n... yes
checking whether to build with Tcl... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build with GSSAPI support... yes
checking whether to build with PAM support... no
checking whether to build with BSD Authentication support... no
checking whether to build with LDAP support... no
checking whether to build with Bonjour support... yes
checking whether to build with SELinux support... no
checking whether to build with systemd support... no
checking whether to build with XML support... yes
checking for libxml-2.0 >= 2.6.23... yes
checking whether to build with LZ4 support... yes
checking for liblz4... yes
checking whether to build with ZSTD support... yes
checking for libzstd >= 1.4.0... yes
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for ar... ar
checking for a BSD-compatible install... /usr/bin/install -c
checking for tar... /usr/bin/tar
checking whether ln -s works... yes
checking for a thread-safe mkdir -p... config/install-sh -c -d
checking for bison... /opt/local/bin/bison
configure: using bison (GNU Bison) 3.8.2
checking for flex... configure: error: 
*** The installed version of Flex, /usr/bin/flex, is too old to use with PostgreSQL.
*** Flex version 2.5.35 or later is required, but this is flex 2.5.33.
Command failed:  cd "/opt/local/var/macports/build/postgresql17-098f9924/work/postgresql-17.5" && ./configure --prefix=/opt/local PG_SYSROOT=disabled ZIC=/opt/local/var/macports/build/postgresql17-098f9924/work/postgresql-17.5/src/timezone/zic --sysconfdir=/opt/local/etc/postgresql17 --bindir=/opt/local/lib/postgresql17/bin --libdir=/opt/local/lib/postgresql17 --includedir=/opt/local/include/postgresql17 --datadir=/opt/local/share/postgresql17 --docdir=/opt/local/share/doc/postgresql17 --mandir=/opt/local/share/doc/postgresql17/man --with-includes=/opt/local/include --with-libraries=/opt/local/lib --with-openssl --with-bonjour --with-readline --with-zlib --with-lz4 --with-zstd --with-libxml --with-libxslt --with-gssapi --with-uuid=e2fs --with-icu 
Exit code: 1

[dgilman (David Gilman)]

In 83321148bbc57637ed3737a71d766190ef1a4163/macports-ports (master):

postgresql17: update to 17.6

Closes: #72742

[dgilman (David Gilman)]

In 83321148bbc57637ed3737a71d766190ef1a4163/macports-ports (master):

postgresql17: update to 17.6

Closes: #72742