Determining installed PostgreSQL

["D'Arcy J.M. Cain" <darcy%NetBSD.org@localhost>]

I just tried to install a package that depends on PostgreSQL and
although I have PostgreSQL 9.0 installed and "SQL_VERSION_DEFAULT
= 90" defined in /etc/mk.conf it still tries to install PostgreSQL 8.3
which fails due to the conflict with 9.0.  The culprit seems to be
pgsql.buildlink3.mk in .../mk which is looking for files of the form
${LOCALBASE}/lib/libecpg.so.6.0.x but the PostgreSQL packages install
files like ${LOCALBASE}/lib/libecpg.so.6.x instead.  The following
fixes the issue for me but I have no Darwin system to test on.  Is this
correct or is the problem rooted elsewhere?

Index: pgsql.buildlink3.mk
===================================================================
RCS file: /cvsroot/pkgsrc/mk/pgsql.buildlink3.mk,v
retrieving revision 1.30
diff -u -r1.30 pgsql.buildlink3.mk
--- pgsql.buildlink3.mk 12 Oct 2010 16:44:19 -0000      1.30
+++ pgsql.buildlink3.mk 8 May 2011 14:38:01 -0000
@@ -41,23 +41,23 @@
 
 # check what is installed
 .if ${OPSYS} == "Darwin"
-.if exists(${LOCALBASE}/lib/libecpg.6.0.2.dylib)
+.if exists(${LOCALBASE}/lib/libecpg.6.2.dylib)
 _PGSQL_VERSION_90_INSTALLED=   yes
 .endif
-.if exists(${LOCALBASE}/lib/libecpg.6.0.1.dylib)
+.if exists(${LOCALBASE}/lib/libecpg.6.1.dylib)
 _PGSQL_VERSION_84_INSTALLED=   yes
 .endif
-.if exists(${LOCALBASE}/lib/libecpg.6.0.0.dylib)
+.if exists(${LOCALBASE}/lib/libecpg.6.0.dylib)
 _PGSQL_VERSION_83_INSTALLED=   yes
 .endif
 .else
-.if exists(${LOCALBASE}/lib/libecpg.so.6.0.2)
+.if exists(${LOCALBASE}/lib/libecpg.so.6.2)
 _PGSQL_VERSION_90_INSTALLED=   yes
 .endif
-.if exists(${LOCALBASE}/lib/libecpg.so.6.0.1)
+.if exists(${LOCALBASE}/lib/libecpg.so.6.1)
 _PGSQL_VERSION_84_INSTALLED=   yes
 .endif
-.if exists(${LOCALBASE}/lib/libecpg.so.6.0.0)
+.if exists(${LOCALBASE}/lib/libecpg.so.6.0)
 _PGSQL_VERSION_83_INSTALLED=   yes
 .endif
 .endif

-- 
D'Arcy J.M. Cain <darcy%NetBSD.org@localhost>
http://www.NetBSD.org/