Description:

PostgreSQL on Arch is compiled with very few options. One that I miss very much is --with-perl in order to be able to use procedural language PL/Perl, without having to recompile PostgreSQL alltogether. IMHO when compiling PostgreSQL more flags should be used.

Additional info:
=== Here is pg_config from Arch for libs and configure:

postgres@gwenllian:data$ pg_config --configure
'--prefix=/usr' '--mandir=/usr/share/man' '--with-libxml' '--with-docdir=/usr/share/doc' '--with-openssl' '--with-python' '--with-pam' '--datadir=/usr/share/postgresql' '--enable-thread-safety' 'CFLAGS=-march=x86-64 -mtune=generic -O2 -pipe' 'LDFLAGS=-Wl,--hash-style=gnu -Wl,--as-needed'

pg_config --libs
-lpgport -lxml2 -lpam -lssl -lcrypto -lz -lreadline -lcrypt -ldl -lm

==== Here's a hint (from Debian): (leave specific flags (like paths and suchs) aside)

root@r19677:~# pg_config --libs
-lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm

root@r19677:~# pg_config --configure
'--build=x86_64-linux-gnu' '--prefix=/usr' '--includedir=/usr/include' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var' '--libexecdir=/usr/lib/postgresql-8.3' '--disable-maintainer-mode' '--disable-dependency-tracking' '--srcdir=.' '--mandir=/usr/share/postgresql/8.3/man' '--with-docdir=/usr/share/doc/postgresql-doc-8.3' '--sysconfdir=/etc/postgresql-common' '--datadir=/usr/share/postgresql/8.3' '--bindir=/usr/lib/postgresql/8.3/bin' '--includedir=/usr/include/postgresql/' '--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety' '--enable-debug' '--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-krb5' '--with-gssapi' '--with-openssl' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-ossp-uuid' '--with-gnu-ld' '--with-tclconfig=/usr/lib/tcl8.5' '--with-tkconfig=/usr/lib/tk8.5' '--with-includes=/usr/include/tcl8.5' '--with-system-tzdata=/usr/share/zoneinfo' '--with-pgport=5432' 'CFLAGS=-g -O2 -g -Wall -O2 -fPIC' 'LDFLAGS= -Wl,--as-needed' 'CC=cc' 'CPPFLAGS=' 'build_alias=x86_64-linux-gnu'

Steps to reproduce:

Recompile PostgreSQL with feasible flags from the above to have a much features complete PostgreSQL.


Thank you for your efforts to make Arch a great distro =)

--
cga