From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Apr 16 09:50:01 2010 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 BB8AA1065676 for ; Fri, 16 Apr 2010 09:50:01 +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 7EF238FC20 for ; Fri, 16 Apr 2010 09:50:01 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id o3G9o12F050077 for ; Fri, 16 Apr 2010 09:50:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id o3G9o1SG050076; Fri, 16 Apr 2010 09:50:01 GMT (envelope-from gnats) Resent-Date: Fri, 16 Apr 2010 09:50:01 GMT Resent-Message-Id: <201004160950.o3G9o1SG050076@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 04D8F106566C for ; Fri, 16 Apr 2010 09:45:54 +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 E8C5E8FC14 for ; Fri, 16 Apr 2010 09:45:53 +0000 (UTC) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.3/8.14.3) with ESMTP id o3G9jrZX083431 for ; Fri, 16 Apr 2010 09:45:53 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.3/8.14.3/Submit) id o3G9jrCO083430; Fri, 16 Apr 2010 09:45:53 GMT (envelope-from nobody) Message-Id: <201004160945.o3G9jrCO083430@www.freebsd.org> Date: Fri, 16 Apr 2010 09:45:53 GMT From: "O. Hartmann" To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/145753: databases/mantis: failure in creating tables with PostgreSQL 8.4 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, 16 Apr 2010 09:50:01 -0000 >Number: 145753 >Category: ports >Synopsis: databases/mantis: failure in creating tables with PostgreSQL 8.4 >Confidential: no >Severity: serious >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Fri Apr 16 09:50:01 UTC 2010 >Closed-Date: >Last-Modified: >Originator: O. Hartmann >Release: FreeBSD 8.0-STABLE/amd64 >Organization: FU Berlin >Environment: >Description: Installation of mantis with postgres-8.4.3 results in this error: BAD CREATE TABLE mantis_bug_table ( id SERIAL, project_id INTEGER DEFAULT 0 NOT NULL, reporter_id INTEGER DEFAULT 0 NOT NULL, handler_id INTEGER DEFAULT 0 NOT NULL, duplicate_id INTEGER DEFAULT 0 NOT NULL, priority INT2 DEFAULT 30 NOT NULL, severity INT2 DEFAULT 50 NOT NULL, reproducibility INT2 DEFAULT 10 NOT NULL, status INT2 DEFAULT 10 NOT NULL, resolution INT2 DEFAULT 10 NOT NULL, projection INT2 DEFAULT 10 NOT NULL, category VARCHAR(64) DEFAULT '' NOT NULL, date_submitted TIMESTAMP DEFAULT '1970-01-01 00:00:01' NOT NULL, last_updated TIMESTAMP DEFAULT '1970-01-01 00:00:01' NOT NULL, eta INT2 DEFAULT 10 NOT NULL, bug_text_id INTEGER DEFAULT 0 NOT NULL, os VARCHAR(32) DEFAULT '' NOT NULL, os_build VARCHAR(32) DEFAULT '' NOT NULL, platform VARCHAR(32) DEFAULT '' NOT NULL, version VARCHAR(64) DEFAULT '' NOT NULL, fixed_in_version VARCHAR(64) DEFAULT '' NOT NULL, build VARCHAR(32) DEFAULT '' NOT NULL, profile_id INTEGER DEFAULT 0 NOT NULL, view_state INT2 DEFAULT 10 NOT NULL, sum mary VARCHAR(128) DEFAULT '' NOT NULL, sponsorship_total INTEGER DEFAULT 0 NOT NULL, sticky BOOLEAN DEFAULT 0 NOT NULL, PRIMARY KEY (id) ) ERROR: column "sticky" is of type boolean but default expression is of type integer HINT: You will need to rewrite or cast the expression. >How-To-Repeat: >Fix: >Release-Note: >Audit-Trail: >Unformatted: