postgresql-devel fails to build on Snow Leopard

[permezel@…]

# port install postgresql-server-devel
--->  Computing dependencies for postgresql-server-devel
--->  Fetching bison
--->  Verifying checksum(s) for bison
--->  Extracting bison
--->  Configuring bison
--->  Building bison
--->  Staging bison into destroot
--->  Installing bison @2.4.1_0
--->  Activating bison @2.4.1_0
--->  Cleaning bison
--->  Fetching ossp-uuid
--->  Attempting to fetch uuid-1.6.2.tar.gz from http://aarnet.au.distfiles.macports.org/pub/macports/mpdistfiles/ossp-uuid
--->  Verifying checksum(s) for ossp-uuid
--->  Extracting ossp-uuid
--->  Applying patches to ossp-uuid
--->  Configuring ossp-uuid
--->  Building ossp-uuid
--->  Staging ossp-uuid into destroot
--->  Installing ossp-uuid @1.6.2_0
--->  Activating ossp-uuid @1.6.2_0
--->  Cleaning ossp-uuid
--->  Fetching postgresql-devel
--->  Verifying checksum(s) for postgresql-devel
--->  Extracting postgresql-devel
--->  Configuring postgresql-devel
--->  Building postgresql-devel
Error: Target org.macports.build returned: shell command " cd "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_postgresql-devel/work/pgsql" && /usr/bin/gnumake -j5 " returned error 2
Command output: rm -f libecpg_compat.dylib
ln -s libecpg_compat.3.1.dylib libecpg_compat.dylib
/usr/bin/gnumake -C preproc all
/usr/bin/gnumake -C ../../../../src/port all
"/opt/local/bin/perl" ./parse.pl . < ../../../../src/backend/parser/gram.y > preproc.y 
/usr/bin/flex  -o'pgc.c' pgc.l
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o type.o type.c
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o ecpg.o ecpg.c
gnumake[5]: Nothing to be done for `all'.
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o output.o output.c
rm -f kwlookup.c && ln -s ../../../../src/backend/parser/kwlookup.c .
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o descriptor.o descriptor.c
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o variable.o variable.c
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o kwlookup.o kwlookup.c
bison -d  -o preproc.c preproc.y
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o preproc.o preproc.c
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o parser.o parser.c
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o keywords.o keywords.c
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o c_keywords.o c_keywords.c
/usr/bin/gcc-4.2 -no-cpp-precomp -O2 -arch x86_64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -Kthread -kthread -pthread -pthreads  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DECPG_COMPILE -I../include -I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4 -DMINOR_VERSION=5 -DPATCHLEVEL=0 -I../../../../src/include -I/opt/local/include -I/opt/local/include/ossp -I/opt/local/include/libxml2  -I/opt/local/include  -c -o ecpg_keywords.o ecpg_keywords.c
In file included from preproc.y:11945:
pgc.c:161: error: conflicting types for 'yyleng'
extern.h:43: error: previous declaration of 'yyleng' was here
pgc.c:288: error: conflicting types for 'yyleng'
extern.h:43: error: previous declaration of 'yyleng' was here
gnumake[4]: *** [preproc.o] Error 1
gnumake[3]: *** [all] Error 2
gnumake[2]: *** [all] Error 2
gnumake[1]: *** [all] Error 2
gnumake: *** [all] Error 2

Error: The following dependencies failed to build: postgresql-devel
Error: Status 1 encountered during processing.
# 

[chepra@…]

This port is heavily outdated.

I suggest that this port will be deleted.

For using lastest postgresql source code I suggest to use the postgresql84 port

--Chepra

[ryandesign (Ryan Carsten Schmidt)]

Has duplicates #24630, #26161, #27182. I agree the port should go away, but before it is deleted, it should be marked as "replaced_by postgresql91" (since postgresql91 is the port tracking the current development version of PostgreSQL).

[ryandesign (Ryan Carsten Schmidt)]

Done in r73205.

[ryandesign (Ryan Carsten Schmidt)]

Oops, since MacPorts would ordinarily consider "9.1alpha" to be less than "20090613" but we want it to be seen to be greater, I needed to have increased the epoch; done in r73206.