I'm using latest postgresql-server and mantisbt-1.1.2-r1, but when I install it, I get next 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, summary 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. I found this error on mantice site http://www.mantisbt.org/bugs/view.php?id=7755 Reproducible: Always
Alexey, regretfully current current stable branch (1.1.X) is broken with postgresql. This is not the only problem with mantisbt and postgresql but it's possible that most (all?) problems are already fixed in svn. Backporting of the patches is non trivial task I've tried to do but failed as too many intrusive changes were required. Resume: Use mantisbt with mysql database. If you really need to run it with postgresql download svn sources from: https://sourceforge.net/svn/?group_id=14963 So resolving this bug as UPSTREAM...
And as a final accord to this bug I've added notice to ebuild about this problem: http://sources.gentoo.org/viewcvs.py/gentoo-x86/www-apps/mantisbt/mantisbt-1.1.2-r1.ebuild?r1=1.3&r2=1.4 And although we fixed nothing, thank you for report Alexey.