Error during the install process

[Sergio]

During the install process of Mantis 1.1.0a4 and using a PostgreSQL 8.1.9 database occurs the following problem.

CREATE TABLE mantis_bug_table ( id SERIAL,
...
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.

What can I do? Rewrite the sentence? Where?

TIA

[nomikon]

I'm testing the latest 1.1.0rc3 version with PostgreSQL 8.1.10 and I get the same error while creating that table:


Schema CreateTableSQL ( mantis_bug_table )
...
ERROR: column "sticky" is of type boolean but default expression is of type integer HINT: You will need to rewrite or cast the expression.


Is there anyone having some success installing Mantis with PostgreSQL?

Regards, NK.

[budershank]

I am having the same issue on Mantis 1.1.1 and PostgresSQL 8.2