Upstream released 0.9.0.1 with our patch as the only change. So let's update to that version and drop our local patch. Tested on amd64.
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/hs-postgresql-libpq/Makefile,v retrieving revision 1.9 diff -u -p -r1.9 Makefile --- Makefile 24 Apr 2014 16:20:34 -0000 1.9 +++ Makefile 7 Jun 2014 23:47:54 -0000 @@ -2,8 +2,7 @@ COMMENT = low-level binding to libpq -DISTNAME = postgresql-libpq-0.9.0.0 -REVISION = 0 +DISTNAME = postgresql-libpq-0.9.0.1 CATEGORIES = databases HOMEPAGE = https://github.com/lpsmith/postgresql-libpq Index: distinfo =================================================================== RCS file: /cvs/ports/databases/hs-postgresql-libpq/distinfo,v retrieving revision 1.5 diff -u -p -r1.5 distinfo --- distinfo 31 Mar 2014 21:45:37 -0000 1.5 +++ distinfo 7 Jun 2014 23:47:54 -0000 @@ -1,2 +1,2 @@ -SHA256 (ghc/postgresql-libpq-0.9.0.0.tar.gz) = Y98ThkE2itgF+uYYSzVmgSMb6q9rGHKh/AJ4uq8FcSU= -SIZE (ghc/postgresql-libpq-0.9.0.0.tar.gz) = 26678 +SHA256 (ghc/postgresql-libpq-0.9.0.1.tar.gz) = o/88Cn3qC+Fe7oIe7kaCtzw804qlGW0EqFiqXOdNvzk= +SIZE (ghc/postgresql-libpq-0.9.0.1.tar.gz) = 26653 Index: patches/patch-postgresql-libpq_cabal =================================================================== RCS file: patches/patch-postgresql-libpq_cabal diff -N patches/patch-postgresql-libpq_cabal --- patches/patch-postgresql-libpq_cabal 24 Apr 2014 16:20:34 -0000 1.4 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -$OpenBSD: patch-postgresql-libpq_cabal,v 1.4 2014/04/24 16:20:34 dcoppa Exp $ ---- postgresql-libpq.cabal.orig Wed Apr 23 21:40:16 2014 -+++ postgresql-libpq.cabal Wed Apr 23 21:40:53 2014 -@@ -30,7 +30,7 @@ Library - GHC-Options: -Wall - Extra-Libraries: pq - if os(openbsd) -- Extra-Libraries: crypto ssl com_err asn1 krb5 wind roken heimbase -+ Extra-Libraries: crypto ssl - - -- Other-modules: - Build-tools: hsc2hs