Adding notes works fine for me with a fresh installation of MantisBT 1.3.x and PostgreSQL 8.4.2

Have you remembered to grant permission for your MantisBT user account to use the sequences? The best approach to setting up MantisBT database permissions is to first create a "MantisBT database admin" user that can create, destroy and alter tables. When installing MantisBT, you use this account. After installation you of course need to make a new user which only has the minimum set of permissions needed to use MantisBT. SELECT, INSERT, UPDATE, etc permissions on the tables and the appropriate permissions on the sequences too (don't forget this!).

If you're still stuck, try recreating the primary key on mantis_email_table (the ID column).

as I said, it's an upgrade problem.

The upgrade process should have renamed the sequence. Probably it wasn't accessed directly in the 1.1.x series, or something else changed.

Anyway, renaming the sequence solved my problem (but it won't solve it for other users that upgrade ;-)

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul

I was not able to reproduce this.

Considering that there's an easy workaround anyway (manually renaming the sequence), I'm sure you'll agree that it's not really worth the effort to try and fix this.