From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Jul 17 08:00:15 2009 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E3522106566B for ; Fri, 17 Jul 2009 08:00:15 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id B9A338FC21 for ; Fri, 17 Jul 2009 08:00:15 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.3/8.14.3) with ESMTP id n6H80Fq9007108 for ; Fri, 17 Jul 2009 08:00:15 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.3/8.14.3/Submit) id n6H80FNq007107; Fri, 17 Jul 2009 08:00:15 GMT (envelope-from gnats) Resent-Date: Fri, 17 Jul 2009 08:00:15 GMT Resent-Message-Id: <200907170800.n6H80FNq007107@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, "O. Hartmann" Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 0409F106564A for ; Fri, 17 Jul 2009 07:53:56 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id E59E18FC08 for ; Fri, 17 Jul 2009 07:53:55 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.3/8.14.3) with ESMTP id n6H7rtVx026580 for ; Fri, 17 Jul 2009 07:53:55 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.3/8.14.3/Submit) id n6H7rt3p026579; Fri, 17 Jul 2009 07:53:55 GMT (envelope-from nobody) Message-Id: <200907170753.n6H7rt3p026579@www.freebsd.org> Date: Fri, 17 Jul 2009 07:53:55 GMT From: "O. Hartmann" To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/136856: databases/libdbi-drivers: PostgreSQL >= 8.3 naming changes of UNICODE -> UTF8 encoding X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 17 Jul 2009 08:00:16 -0000 >Number: 136856 >Category: ports >Synopsis: databases/libdbi-drivers: PostgreSQL >= 8.3 naming changes of UNICODE -> UTF8 encoding >Confidential: no >Severity: critical >Priority: high >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Fri Jul 17 08:00:15 UTC 2009 >Closed-Date: >Last-Modified: >Originator: O. Hartmann >Release: FreeBSD 8.0-BETA2/FreeBSD 7.2-STABLE >Organization: FU Berlin >Environment: >Description: PostgreSQL >= 8.3 seems to have renamed the charsetencoding UNICODE to UTF8. This is not reflected by the actual port of libdbi-drivers, but there are actually patches made by M. Hoenicka residing at sourceforge. Using PostgreSQL >= 8.3 in combination with ports/textproc/refdb (which has libdbi-drivers as dependency) results in a non-operating refdb-system since the refdbd doens't know how to handle 'UTF-8', which needs to be mapped as 'UTF8' by the libdbi-driver/pgsql. The patch is simple, I added a line in drivers/pgsql/dbd_pgsql.c. Maybe the maintainer would please have a look on the several fixes that already have been made by the development crew including this one I mention made by M. Hoenicka (he solved this issue while we have had personal communication). >How-To-Repeat: Build textproc/refdb with databases.postgresql8[34]-server|client with actual databases/libdbi-drivers. Then fill up the refdb-tables in PostgrSQL with the testdata and try to retrieve references with 'getref'. This will never succeed until you patch libdbi-drivers as mentioned. >Fix: Apply appended patch. Patch attached with submission follows: --- drivers/pgsql/dbd_pgsql.c.orig 2009-07-16 17:11:32.000000000 +0200 +++ drivers/pgsql/dbd_pgsql.c 2009-07-16 17:11:48.000000000 +0200 @@ -75,6 +75,7 @@ "EUC_JP", "EUC-JP", "EUC_KR", "EUC-KR", "UNICODE", "UTF-8", + "UTF8", "UTF-8", "LATIN1", "ISO-8859-1", "LATIN2", "ISO-8859-2", "LATIN3", "ISO-8859-3", >Release-Note: >Audit-Trail: >Unformatted: