From owner-freebsd-ports@freebsd.org Tue Aug 25 10:46:30 2015 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 4997B99EB9C for ; Tue, 25 Aug 2015 10:46:30 +0000 (UTC) (envelope-from cmt@burggraben.net) Received: from smtp.burggraben.net (smtp.burggraben.net [IPv6:2a01:4f8:140:50a2::3:1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "ns.exwg.net", Issuer "Christoph Moench-Tegeder" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 0A52A68A for ; Tue, 25 Aug 2015 10:46:29 +0000 (UTC) (envelope-from cmt@burggraben.net) Received: from localhost (localhost [127.0.0.1]) by smtp.burggraben.net (Postfix) with ESMTP id 4CA1B6000AF for ; Tue, 25 Aug 2015 12:46:27 +0200 (CEST) X-Spam-Scanned: by amavisd-new at exwg.net Received: from smtp.burggraben.net ([127.0.0.1]) by localhost (ns.burggraben.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HsgdTLLh-fcg for ; Tue, 25 Aug 2015 12:46:26 +0200 (CEST) Received: from elch.exwg.net (dslb-088-066-023-238.088.066.pools.vodafone-ip.de [88.66.23.238]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "elch.exwg.net", Issuer "Christoph Moench-Tegeder" (verified OK)) by smtp.burggraben.net (Postfix) with ESMTPS for ; Tue, 25 Aug 2015 12:46:26 +0200 (CEST) Received: by elch.exwg.net (Postfix, from userid 1000) id 606DF30205; Tue, 25 Aug 2015 12:46:26 +0200 (CEST) Date: Tue, 25 Aug 2015 12:46:26 +0200 From: Christoph Moench-Tegeder To: freebsd-ports@freebsd.org Subject: Re: Postgresql 92 XML gone? Message-ID: <20150825104626.GA42828@elch.exwg.net> References: <55BDDBE1.1090101@netfence.it> <1CC43015-DB2D-4A3F-B148-34ED47E1DD9D@pingpong.net> <1438515346.2428.2.camel@heesakkers.info> <55DAF168.5050701@netfence.it> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <55DAF168.5050701@netfence.it> User-Agent: Mutt/1.5.23 (2014-03-12) X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 25 Aug 2015 10:46:30 -0000 ## Andrea Venturoli (ml@netfence.it): > I added postgresql92-contrib, then issued > # create extension xml; The extension has been renamed to xml2, as you already noticed :) http://www.postgresql.org/docs/9.2/static/xml2.html Please mind that there's a built-in xml datatype, and additional funtions: http://www.postgresql.org/docs/9.2/static/datatype-xml.html http://www.postgresql.org/docs/9.2/static/functions-xml.html Additionally, you're encouraged to use the latest PostgreSQL version, that is 9.4 these days. > However: > > # create extension xml2; > > ERROR: could not load library "/usr/local/lib/postgresql/pgxml.so": dlopen (/usr/local/lib/postgresql/pgxml.so) failed: /usr/local/lib/postgresql/pgxml.so: Undefined symbol "xml_ereport" Oh well: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=202649 Please mind that the built-in XML support is (mostly) unavailable without that patch. Regards, Christoph -- Spare Space