From owner-freebsd-ports-bugs@FreeBSD.ORG Thu Jul 9 17:30:02 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 757D6106566C for ; Thu, 9 Jul 2009 17:30:02 +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 5014B8FC1D for ; Thu, 9 Jul 2009 17:30:02 +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 n69HU2ne034370 for ; Thu, 9 Jul 2009 17:30:02 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.3/8.14.3/Submit) id n69HU26U034369; Thu, 9 Jul 2009 17:30:02 GMT (envelope-from gnats) Resent-Date: Thu, 9 Jul 2009 17:30:02 GMT Resent-Message-Id: <200907091730.n69HU26U034369@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, Richard Tector Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id ACAD410656AC for ; Thu, 9 Jul 2009 17:21:41 +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 9AA1E8FC1A for ; Thu, 9 Jul 2009 17:21:41 +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 n69HLfbC087858 for ; Thu, 9 Jul 2009 17:21:41 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.3/8.14.3/Submit) id n69HLfGK087857; Thu, 9 Jul 2009 17:21:41 GMT (envelope-from nobody) Message-Id: <200907091721.n69HLfGK087857@www.freebsd.org> Date: Thu, 9 Jul 2009 17:21:41 GMT From: Richard Tector To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/136625: databases/postgresql84-server defaults to 32bit date/time 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: Thu, 09 Jul 2009 17:30:02 -0000 >Number: 136625 >Category: ports >Synopsis: databases/postgresql84-server defaults to 32bit date/time >Confidential: no >Severity: non-critical >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Thu Jul 09 17:30:01 UTC 2009 >Closed-Date: >Last-Modified: >Originator: Richard Tector >Release: >Organization: >Environment: FreeBSD moses.thekeelecentre.com 7.2-STABLE FreeBSD 7.2-STABLE #0: Wed Jun 10 18:24:51 BST 2009 richard@moses.thekeelecentre.com:/usr/obj/usr/src/sys/MOSES amd64 >Description: PostgreSQL 8.4 now defaults to using a 64bit date/time field: http://www.postgresql.org/docs/8.4/static/release-8-4.html#AEN94019 This both fixes the build option (now --disable-integer-datetime) and sets the default to enabled, as per the standard Postgres build. Users moving from 8.3 to 8.4 must dump/restore their databases in any case, so datafile compatibility should not be an issue. Furthermore, I believe that those users who have already made the switch should not have a problem since they will have 64 bit datetimes already, the old build option being ignored. >How-To-Repeat: >Fix: See attached. Patch attached with submission follows: --- Makefile.old 2009-07-09 17:58:00.000000000 +0100 +++ Makefile 2009-07-09 18:11:58.000000000 +0100 @@ -100,7 +100,7 @@ # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) -OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off +OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" on #. if (defined(SERVER_ONLY) && defined(WITH_ICU)) || make(makesum) #USE_AUTOTOOLS= autoconf:262 @@ -133,8 +133,8 @@ PLIST_SUB+= TZDATA="@comment " . endif -. if defined(WITH_INTDATE) -CONFIGURE_ARGS+=--enable-integer-datetimes +. if defined(WITHOUT_INTDATE) +CONFIGURE_ARGS+=--disable-integer-datetimes . endif . if !(defined(WITHOUT_GETTEXT) || defined(WITHOUT_NLS)) >Release-Note: >Audit-Trail: >Unformatted: